开发者

How to GRANT in mysql after REVOKE

开发者 https://www.devze.com 2023-02-17 16:36 出处:网络
In mysql i executed following command REVOKE ALL PRIVILEGES after that i t开发者_开发问答ry to give GRANT then it shows Access deniedit would seem that you revoked the GRANT privileges of your own us

In mysql i executed following command REVOKE ALL PRIVILEGES after that i t开发者_开发问答ry to give GRANT then it shows Access denied


it would seem that you revoked the GRANT privileges of your own user, you should use the root user to grant those privileges back.

for a review of your status regarding the privileges run from root user:

SHOW GRANTS;
0

精彩评论

暂无评论...
验证码 换一张
取 消