Shulou(Shulou.com)06/01 Report--

This article will explain in detail the steps of how to skip permissions in Mysql. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Today in the project encountered such a problem, I forgot my mysql password, so I can not link to the database, Baidu online, very simple, take a note, in order to quickly solve the problem of children's shoes like me.

1. Kill the mysql process (stop the mysql service)

Service mysql stop

two。 Start mysql without checking permissions

Mysqld_safe-skip-grant-tables

3. Log in to mysql

Mysql-uroot

4. Modify root user password

UPDATE user SET password=PASSWORD ('123456') WHERE user='root'

5. Refresh permissions

Flush privileges;quit

6. Restart MySQL

Service mysql restart

It's that simple.

This is the end of the steps on how to skip the permission of Mysql. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can 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.