The solution of unable to log in locally after mysql modifies the permission
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!