How to change MySQL user password

In the process of using the MySQL database, we often need to change the password of the database user. This operation is very important and can protect the security of the database. This article will introduce you how to change the MySQL user password.

1. Use the command line to change the MySQL user password

Step 1: Log in to the MySQL database

Use the following command to log in to the MySQL database and enter the password:

mysql -u 用户名 -p

For example:

mysql -u root -p

Step 2: Select the corresponding database

Use the following command to select the database that needs to change the password:

USE 数据库名

For example:

USE mydb;

Step 3: Change the user password

Use the following command to change the password of the database user:

ALTER USER ' username ' @ ' % ' IDENTIFIED BY ' password ';

Among them, username is the user who needs to change the password, % means that any host can connect to MySQL, and password is new password. For example:

ALTER USER 'root'@'%' IDENTIFIED BY 'newpassword';

Step 4: Refresh permissions

Use the following command to refresh permissions:

FLUSH PRIVILEGES;

2. Use phpMyAdmin to modify the MySQL user password

phpMyAdmin is A Web-based MySQL database management tool that provides a graphical interface to manage MySQL databases.

Step one: Log in to phpMyAdmin

Open the browser and enter the following URL to enter the phpMyAdmin login page:

http://服务器IP/phpMyAdmin

For example:

http://127.0.0.1/phpMyAdmin

Enter the MySQL database Username and password, click to log in.

Step 2: Select the corresponding database

Select the database whose password needs to be changed in the left navigation bar.

Step 3: Select the corresponding user

Select "User Account" in the navigation bar.

Find the user whose password needs to be changed and click "Edit".

Step 4: Modify user password

On the "Edit User Account" page, enter the new password and click "Go".

Step 5: Refresh permissions

Log in to the MySQL database again and refresh permissions.

Summary

Both of the above two methods can modify the MySQL user password, among which the command line method is more flexible and phpMyAdmin is more convenient. No matter which method is used, be sure to refresh the permissions in time after changing the password to avoid problems. Correctly changing the MySQL user password can effectively protect the security of the database. It is recommended to change it frequently.

The above is the detailed content of How to change MySQL user password. For more information, please follow other related articles on the PHP Chinese website!