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

Found that after the previous article solved the problem that the mysql service could not be started, it turned out that root users could not log in without a password, and version 5.7 could not log in with root without a password during initialization. After looking for many posts, the problem was solved.

It turns out that in the data file generated by the mysqld-initialize method in the previous article, the .err file can be opened with word, and there will be a temporary initial password to generate root.

Find the password after opening it:

But this password will expire after using it once and cannot be used. Next, let's change this password.

1. Shut down mysql service and net stop mysql first.

2. Modify your mysql configuration file my.ini or my-default.int, depending on which file you modify according to your own configuration.

3. Add skip-grant-tables to the [mysqld] node

The main function is to skip the verification in the table and log in without a password.

4. Open the mysql service (net start mysql) and use the visualization client to enter mysql. The visualization client I use, mysqlFront, you can go to Baidu to find it.

5. Open the user table under mysql and change the Y of the password_expired field to N; there are two ways to change the password: y: invalid, n: valid. Remember to save it after the change.

6. Stop the mysql service, delete the skip-grant-tables in the ini file, and restart the service.

7. Change the password: mysqladmin-u root password root

Enter the original password, that is, the modification is successful. The last root is the new password

After the password has been changed, you can log in, mysql-uroot-p

Enter the password you just set and root can log in.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.