Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "how to change the mysql login password", the editor shows you the operation process through the actual case, the operation method is simple and fast, practical, I hope this "how to change the mysql login password" article can help you solve the problem.

Modification method: 1, open the cmd command window, execute the "mysql-u root-p" command and enter the password, log in to mysql;2 with root authority, execute the "set password for user name @ localhost=password (" new password ");" command to change the password.

The operating environment of this tutorial: windows10 system, mysql5.7.29 version, Dell G3 computer.

When using the database, we may encounter situations where MySQL needs to change the password, such as the password is too simple and needs to be changed.

The method of changing mysql login password

Premise: log in to mysql with root permission and modify ordinary users

Steps:

1. Open the cmd command window, execute the command mysql-u root-p to specify the root user to log in to MySQL, enter and press enter to enter the password.

2. Use SET PASSWORD to change the password

The format of the command is:

Set password for username@localhost = password (newpwd)

Where username is the user name to change the password, and newpwd is the new password to be modified.

As shown in the figure:

Then enter the quit; command to log out of MySQL and log in again, and you can log in with the new password "root"!

This is the end of the introduction on "how to change the mysql login password". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.