How to realize the recovery of user Rights by mysql

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.