How to set password for root user in MySQL

MySQL is a popular relational database management system, and setting a password including MySQL is very important as it ensures the security of your database is protected. This article will help you understand how to set a password for the root user in MySQL. The following are the steps:

Step 1: Log in to MySQL as the root user

First, we need to log in to MySQL as the root user Log in to MySQL. Run the following command in a terminal window:

mysql -u root -p

Next, you need to enter the password of your MySQL root user. If you haven't set a password yet, skip to step 2.

Step 2: Modify the root password

If you have not set the MySQL root password, you can follow the steps below to set it. In the MySQL command line, run the following command:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';

Be sure to replace password with the password you want to set.

Step 3: Refresh permissions

After setting the new password for the root user, you need to refresh the permissions in MySQL. In the MySQL command line, run the following command:

FLUSH PRIVILEGES;

At this point, you have successfully completed setting the password of the root user in MySQL.

Step 4: Test the new password

Finally, you can test your new password by simply exiting the MySQL command line and then logging back into MySQL as the root user again. If you successfully log in to MySQL, your new password has been set successfully.

Summary

Setting the root user's password in MySQL is a critical security step. The above steps should help you set a new password for the root user and protect the security of your MySQL database. Please make sure to use these steps for all MySQL instances.

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