Detailed introduction to the solution for mysql forgotten password and three ways to change the password

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.

1. Three ways to change passwords

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:

1.1. Use the mysqladmin command to specify a new password on the command line

mysqladmin -u root -p password ‘新密码’

Press Enter and you will be reminded to enter the original password

1.2. Use the set statement

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

1.3. Modify the user table

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

1.4. Modify password statement in mysql8.0

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

If an error is reported, first execute flush privileges

2. What should I do if I forget my password?

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!