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

The blogger encountered this problem today without using mysql for a month or two. my solution is like this, you can also refer to the following.

1. Win+R, enter services.msc to open the service and close the MySQL57 service (57 is the version number of my MySQL Server)

2. Right-click the attribute, and you need to enter this similar command in cmd.

Enter cmd,cd C:/Appserv/MySQL//bin to enter into the bin directory while running, and then mysqld-- defaults-file= "C:/Appserv/MySQL/my.ini"-- skip-grant-tables. This command is to cancel login with password.

3. Win+R, enter cmd, and then mysql-uroot-p. If Enter passwrod appears later, you can enter directly by pressing enter.

Enter flush privileges; and then you can add the password of the user name to root

What I do is change the password directly in Navicat Premium.

What you do is to enter the root user password and enter the following command

Use mysqlset password = password ('you want the newly set password')

5. Finally, you use mysql-uroot-p in cmd (your new password will definitely get 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.