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
MySQL user privileges MySQL user privileges Temporary disable write to binlog Temporary disable write to binlog Show available collations Show available collations
Recommendations
MySQL user privileges MySQL user privileges Temporary disable write to binlog Temporary disable write to binlog
On this page
MySQL - grants