Get the App
SLTechnology News&Howtos  ›  Database  › 

The solution of unable to log in locally after mysql modifies the permission

Shulou Source: shulou.com Published: 2022-06-01 04:12:36 11月16日 Update

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!

Tags: Permissions methods login commands content passwords articles services not much most more knowledge industry information information channels channels references learning help Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Microsoft Shulou Technology Redmi Apple OPPO Reno