mysql root change password

MySQL is an open source relational database management system suitable for various applications such as website services, online database management, and data storage. When we need to change the password of the root user in MySQL, we need to master some relevant knowledge and operations.

1. Determine the MySQL version

First, we need to determine the MySQL version used. We can enter the following command to confirm:

mysql --version

This command will output the MySQL version number.

2. Stop the MySQL service

Before changing the MySQL password, we need to stop the MySQL service first. We can stop the MySQL service through the following command:

sudo systemctl stop mysql

This command will stop the MySQL service and release all occupied resources.

3. Enter MySQL command mode

We need to use a privileged identity to enter MySQL command mode. We can enter through the following command:

sudo mysql -u root -p

After entering the above command, the system will prompt you to enter the password of the root user. If the input is correct, you can successfully enter the MySQL command mode.

4. Modify root user password

We need to enter the following command in MySQL command mode to modify the password:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Among them, 'new_password' needs to be replaced into the new password you wish to set. After entering the command, MySQL will automatically save the new password you set.

5. Check whether the new password is effective

After entering the password modification command, we need to check whether the new password is effective. We can view it through the following command:

mysql> SELECT user, host, plugin FROM mysql.user WHERE user = 'root';

In the output result, we can view the user's name, host address, password encryption algorithm and other information. If the new password has taken effect, you can see that the password encryption algorithm is no longer 'auth_socket', but 'caching_sha2_password'.

6. Restart the MySQL service

After completing the password change, we need to restart the MySQL service. We can start it with the following command:

sudo systemctl start mysql

This command will restart the MySQL service and make the new password take effect.

Summary

Changing the password of the MySQL root user is a relatively basic operation, but it requires relevant knowledge of the MySQL command mode. Before changing the password, you need to make sure to stop the MySQL service and enter the MySQL command mode. After changing the password, you need to check whether the new password takes effect and restart the MySQL service. These operations need to be handled with caution to avoid irreversible consequences for the database.

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