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

Xiaobian to share with you the solution to mysql password forgetting, I believe most people still do not know how to, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

MySQL password forgotten solution: first find the configuration file to add [skip-grant-tables]; then restart the mysql service, password free login, enter the terminal; finally modify to become your own password.

The solution to mysql password forgetting:

Step 1: Find the configuration file under the mysql installation directory, usually my.ini. And under [mysqld], add skip-grant-tables and save the file. The operation is as follows:

Step 2: Restart the mysql service by: right-clicking on my computer-> Services-> Find mysql service to restart.

Step 3: Secret-free login, enter the terminal, type mysql -u root -p command and enter, then you can enter directly

Step 4: Change the password to your own. Enter set password for 'username'@'host' = password ('newpassword ') on the terminal.

Note: If you enter mysql -u root -p, it will display as follows:

This indicates that the mysql database has not been started. Right click on my computer-> Services-> Find mysql service to start. Or directly in the terminal input net start mysql can also start.

The above is "mysql password forgotten solution" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to 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.