How to change mysql password

MySQL is a popular relational database management system used to store, manage and retrieve data. MySQL provides a simple and clear way to protect the database, which is to set a password for the database. However, if the password is too simple or leaked, it may pose a serious security threat to the database. This article will introduce how to change the password of the MySQL database.

1. Login to MySQL

To change the MySQL password, you first need to log in to the MySQL database. You can use the following command in the terminal to log in to MySQL as the root user:

mysql -u root -p

If you have set a password, enter your password and press Enter to log in successfully.

2. Change Password

After logging in to MySQL, the next step is to change the password. To change the password, you need to execute the following command:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';

In the above command, "root" is your user name, "localhost" is your host name, and "new_password" is the new password you want to set. password.

Please note that if you are using MySQL 5.7.6 or higher, you can use the following command to change the password:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

In MySQL 5.7.6 or higher, you You can also use the following command:

UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;

Whichever method you use, remember to replace "new_password" with the new password you want to set.

3. Exit MySQL

After completing the password change, you need to use the "quit" command to exit MySQL:

quit;

In this way, the password has been successfully changed . From now on, you can log in to MySQL again using your new password.

One thing to note is that if you want your password to be purely numeric, remember to enclose it in quotes.

Summary

MySQL database is a very powerful and popular database management system and you need to maintain the security of your database. To change the MySQL password, you need to first log in to MySQL as the root user, and then execute the ALTER USER or SET PASSWORD command. Once completed, you can log in to MySQL again using your new password.

In addition, passwords should be changed regularly and ensure password complexity and security. This can help protect the database from malicious users and hackers.

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