How to add root password in mysql

How to add root password to mysql: 1. Start the database service; 2. Open the command line terminal or MySQL client; 3. After logging in to MySQL, execute ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password ' command to add the root password; 4. After executing the above command, MySQL will update the user's password; 5. Test the new password.

The operating environment of this tutorial: windows10 system, mysql8.0.16 version, DELL G3 computer.

MySQL is a popular open source relational database management system that is widely used as the backend database for a variety of applications. When using MySQL, by default, the root user is the user with the highest authority and can perform all database operations. In order to protect the security of the database, it is recommended to set a password for the root user.

The following will describe in detail how to add the root password in MySQL.

1. First, make sure that the MySQL database management system has been installed and the database service has been started. If you haven't installed MySQL yet, you can download it from the official website and follow the guide to install it.

2. Open a command line terminal or MySQL client to perform the following steps. In Windows systems, you can search and open the MySQL command line client in the Start menu or use the command prompt. In Linux systems, open a terminal and use the command `mysql -u root -p`Log in to MySQL.

3. After logging in to MySQL, you can execute the following command to add the root password:

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

where , `your_password` is the password you want to set. Please note that in this command, we selected `'root'@'localhost'` as the user whose password we want to change. `root` represents the user name, `localhost` represents the connection source, which can be modified as needed.

4. After executing the above command, MySQL will update the user's password and give corresponding feedback. If all goes well, you will see a message indicating that the password has been successfully changed.

5. Test the new password: Use the `EXIT` command to exit the MySQL command line or client, and then use the following command to log in to MySQL again:

mysql -u root -p

The system will prompt you to enter your password. Enter the password you just set and press Enter.

If the password is correct, you will successfully log in to MySQL. Otherwise, the system will display an error message and you will need to re-enter your password.

Through the above steps, you have successfully added a password to the root user. Now, every time you log in to MySQL using the root user, you need to provide the correct password.

This security measure is very important to protect the security of the database and prevent unauthorized access. After setting the root password, make sure to keep it safe and only share it with trusted users.

In day-to-day operations, it is recommended to follow best practices, such as using a user with less privileges to perform common tasks and using the root user only when needed. Additionally, set complex and unique passwords to increase database security .

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