linux mysql password modification

Under Linux systems, MySQL is a very common relational database management software. In practical applications, the MySQL password is very important because it involves data security and the allocation of account permissions. How to change the MySQL password has become a topic worth discussing.

Below we will share how to change the MySQL password under Linux system.

Step 1: Log in to MySQL and enter the command line

Under the Linux system, log in to MySQL through the following command:

mysql -u root -p

Then enter the password of the current MySQL account and enter MySQL. Command Line.

Step 2: Select the account to change the password

In the command line, we can list all current accounts through the following command:

SELECT User FROM mysql.user;

With this command, we can see Find out which MySQL accounts currently exist. Next, we need to select the account that needs to change the password. Suppose we want to change the password of the root account, we can use the following command:

USE mysql;
UPDATE user SET authentication_string=PASSWORD('新密码') WHERE User='root';
FLUSH PRIVILEGES;

Here, change the "new password" to the password you want to set.

Step 3: Restart the MySQL service

After completing the password change, we need to restart the MySQL service and find the directory where the MySQL service is located, usually in the /etc/init.d/ directory, and then Execute the following command:

sudo service mysql restart

In this way, the MySQL service will be restarted and the new password will take effect.

Summary

Under Linux systems, the security of MySQL passwords is crucial. If your password is not secure enough, it can be easily attacked and invaded by hackers. Therefore, we need to change our passwords regularly and set a password that is complex enough. The above steps are simple and easy to perform. We only need to operate step by step in the command line to complete. I hope this article can help you and make your MySQL password more secure.

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