How to change password in MySQL 5.7.18

How to change the password in MySQL 5.7.18:

1. First shut down the MySQL server:

You can shut down mysql directly in the task manager, or you can shut down mysql in cmd: net stop mysql

2. Open the safe mode and log in without a password: In cmd, jump to the installation directory: d:

   cd D:\Mysql\mysql-5.7.18-winx64\bin

Then enter: mysqld --defaults-file="D:\Mysql\mysql-5.7.18-winx64\my.ini" --console --skip-grant-tables (note to modify the installation path yourself)

3. Open another DOS window and enter mysql -uroot -p , then press the enter key to enter without entering a password;

4. Next, open the mysql database: use mysql;

Then enter update mysql.user set authentication_string=password('new password') where user='root';
Then refresh the permissions: flush privileges;
Then exit: quit;

5. Open the MYSQL server! ! ! You can open it manually or enter net start mysql in cmd to open it.

6. Next you can log in using your new password.

The above is the method of changing the password of MySQL5.7.18 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!