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

Editor to share with you the local can not log in after mysql permission modification solution, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

The solution to the local inability to log in after mysql modifies permissions: first, execute the [service mysql stop] command to shut down the mysql service; then execute the [mysqld_safe-- skip-grant-tables &] command to skip the permission table; finally, reset the password.

Solution:

First stop the mysql service

Service mysql stop

Then skip the permissions table

Execute the command:

Mysqld_safe-- skip-grant-tables &

So it won't stop us from logging in.

Finally, just reset the password.

The above are all the contents of the local login solution after mysql modifies the permissions. Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.