MySQL - grants

Moki Lv6
  2022-11-25 05:13:16 2022-11-25 05:13:16 Created   2022-11-25 05:13:16 2022-11-25 05:13:16 Updated   

Show grants for user:

1
SHOW GRANTS FOR user@'%'

Grant privileves for user:

1
GRANT ALL PRIVILEGES ON *.* to user@'%'

Grant privileves for user with allow set grants:

1
GRANT ALL PRIVILEGES ON *.* to user@'%' WITH GRANT OPTION
Recommendations
Temporary disable write to binlog Temporary disable write to binlog SSH proxy SSH proxy Show available collations Show available collations
Recommendations
Temporary disable write to binlog Temporary disable write to binlog SSH proxy SSH proxy
On this page
MySQL - grants