mysql set root password

MySQL is a commonly used relational database management system that is widely used in various types of application development, data management and data processing tasks. In the operation of MySQL, the root account has the highest authority and has no password by default after the installation is completed. Therefore, the security is low and a root password needs to be set to ensure data security. This article will introduce how to set the password of the MySQL root account.

Step 1: Open the MySQL command line

First, you need to open the MySQL command line in order to set the password. In a Windows environment, you can open the MySQL command line in the following way:

1. Enter the MySQL installation directory/bin folder, for example:

C:Program FilesMySQLMySQL Server 8.0 in

2. Hold down the Shift key under the folder, then right-click the mouse and select the "Open PowerShell Window Here" or "Open Command Prompt Here" option.

In Linux or MacOS systems, you can open the MySQL command line through the following command:

$ mysql -u root -p

After entering the command, the system You will be prompted to enter the password for the database root account. If you have not set a password before, just press the Enter key.

Step 2: Enter the MySQL Shell interface to execute the SQL command

Enter the following code in the MySQL command line:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'New Password'

Among them, 'New Password' is the password you want to set, which can be modified according to actual needs.

After execution, a new password will be added to MySQL and the new password will be used to connect.

Step 3: Restart the MySQL service

In order for the changes to take effect, you need to restart the MySQL service. In Windows systems, you can go to Control Panel - System and Security - Administrative Tools - Services, find the MySQL service and restart it. In Linux or MacOS systems, you can use the following commands to restart:

$ sudo service mysql restart

or

$ sudo systemctl restart mysql

Summary

The above are the steps to set the password for the MySQL root account. It should be noted that during the password setting process, users need to set it according to actual needs to ensure data security and reliability. In addition, users are also recommended to change their passwords regularly to improve password complexity and security.

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