Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to achieve user rights recovery in mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Mysql user rights recovery

Show grants for 'monitor'@'%'

+-+

| | Grants for monitor@% |

+-+

| | GRANT USAGE ON *. * TO 'monitor'@'%' IDENTIFIED BY PASSWORD' * 8E043332BD6AAC61C53AE3D835FFF316F00337CC' |

| | GRANT EXECUTE ON "test". * TO 'monitor'@'%' |

| | GRANT ALL PRIVILEGES ON "monitor". * TO 'monitor'@'%' |

| | GRANT SELECT ON "performance_schema". * TO 'monitor'@'%' |

+-+

REVOKE ALL PRIVILEGES ON "monitor". * from 'monitor'@'%'

Grant delete,update,insert,select on "monitor". * TO 'monitor'@'%'

Flush privileges

This is the end of the article on "how to recover user rights in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.