This article will introduce to you the solution for forgetting mysql password and three ways to change the password. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.
mysql users are divided into root users (super administrators, with all permissions) and ordinary users, mysql server User access to the database is controlled through permission tables, which are stored in the mysql database under the root user.
In the process of using the mysql database, it is often necessary to change the password. Here are three ways to change the password:
mysqladmin -u root -p password ‘新密码’
Press Enter and you will be reminded to enter the original password
set password=password(“新密码”)
At this time, you need to restart the mysql server or use the flush privileges statement Refresh the permission table to make the new password take effect
update mysql.user set authentication_string=PASSWORD("123456") where user="root" and host="localhost"
Note that the field used to store user passwords in the new version of mysql is named authentication_string instead of password, and the new password must be used Password function performs encryption
ALTER USER 'root'@'localhost' IDENTIFIED BY 'ok';
If an error is reported, first execute flush privileges
In addition, have you ever encountered the situation of forgetting your password? In fact, forgetting the password is easy to solve. The following is the solution for forgetting the password:
Step 1: Enter the net stop mysql command on the command line to close the mysql service
Step 2: Use - The -skip-grant-tables option starts the mysql service (the server will not load permission judgment, and any user can access the database)
Enter mysqld --skip-grant-tables
After running, the user can no longer enter commands. At this time, if you can see the process named mysqld in the task manager, it means that you can log in to the server as the root user.
Step 3: Open another command line window, enter the login command without password
mysql -u root
After successful login, you can use the update statement to modify the password
After the modification is completed, you must use the flush privileges statement to refresh Permission table, so that the new password can take effect
Step 4: Close the command line window where the mysqld --skip-grant-tables command was entered, and then you can use the new password to log in to the mysql server
How about it? Do you think it is very simple? You no longer have to worry about forgetting your password in the future!
Related recommendations: "mysql tutorial"
The above is the detailed content of Detailed introduction to the solution for mysql forgotten password and three ways to change the password. For more information, please follow other related articles on the PHP Chinese website!