How to set the password for the MySQL root account?

MySQL is a popular relational database management system that is widely used in various Internet applications and enterprise systems. In MySQL, the root account is the account with the highest authority and has full control over the database. Correctly setting the password for the root account is one of the important measures to ensure database security. This article will introduce how to set the password of the MySQL root account and provide specific code examples.

In MySQL, you can use the following steps to set the password of the root account:

Step 1: Log in to MySQL

First, you need to log in to the MySQL database as the root user. Login can be achieved through the command line or graphical interface tools. If you are logging in from the command line, you can use the following command:

mysql -u root -p

This command will prompt you to enter the password of the root account. After entering the correct password, you can log in to MySQL.

Step 2: Modify the root account password

After successful login, you can use the following SQL statement to modify the password of the root account:

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

In the above SQL statement, 'new_password' Is the new password you want to set, you can replace it with any complex password string. After executing the above SQL statement, the password of the root account is successfully modified.

Step 3: Refresh permissions

After modifying the root account password, in order for the permission changes to take effect, the MySQL permission system needs to be refreshed. You can use the following SQL statement to refresh permissions:

FLUSH PRIVILEGES;

After executing the above SQL statement, the above modifications will take effect and be applied to the MySQL permission system.

Through the above steps, we successfully changed the password of the MySQL root account and refreshed the permission system, ensuring the security of the database. When setting the root account password, it is recommended to choose a complex and secure password to prevent unauthorized access and data leakage. Hopefully the specific code examples provided in this article will help you correctly set the MySQL root account password.

The above is the detailed content of How to set the password for the MySQL root account?. For more information, please follow other related articles on the PHP Chinese website!