How to change the password of MySQL5.7.18 and mysql5.7.18

How to change the password of MySQL5.7.18 and mysql5.7.18

How to change the password in MySQL 5.7.18:

1. First shut down the MySQL server:

You can disable mysql directly in the task manager or in cmd.

2. Enable the security mode. you can log on without a password: Jump to the installation directory in cmd: 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(Change the installation path by yourself)

3. Open another dos window and entermysql -uroot -pAnd enter the key directly without entering the password;

4. Open the mysql database: use mysql;

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

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

6. You can log on with the new password.

The above section describes how to change the password of MySQL5.7.18. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!