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

This article will explain in detail the methods of changing passwords in MySQL5.7.18. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

How to change the password in MySQL 5.7.18:

1. First shut down the MySQL server:

You can close it directly in Task Manager or you can close mysql: net stop mysql in cmd

two。 Turn on safe mode to log in 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 (pay attention to modify the installation path yourself)

3. Open another dos window and enter mysql-uroot-p, then enter directly 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 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. Then you can log in with the new password.

On the MySQL5.7.18 password modification method to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.