Forgot MySQL password! ? Don't panic~

mysql tutorial column will help you solve the problem of forgetting your MySQL password.

After installing MySQL or when using MySQL, the most embarrassing thing is to forget the password. Murphy's Law also tells us that if something If something can go wrong, it will go wrong. So what should we do if we accidentally forget the MySQL password? Don't worry, this article will teach you how to do it.

1. Modify the MySQL configuration file

First we need to open the MySQL configuration file. If it is a Windows system, the MySQL configuration file is my.ini, which is in the default installation directory of MySQL. ; If it is a MacOS system, the configuration file name is my.cnf, and its path is /etc/my.cnf.

Taking MacOS as an example, we need to add "skip-grant-tables" after [mysqld] in the configuration file, which means to set up skip permission verification , as shown in the following figure:

MacOS can directly use the "sudo vim /etc/my.cnf" command to edit the configuration file.

Notes

If you cannot find the MySQL configuration file in MacOS, you can create my.cnf directly in the /etc directory and add the following content:

[client] default-character-set=utf8

[mysqld] bind-address = 127.0.0.1 character-set-server=utf8 skip-grant-tables

Of course, if there are other configuration items, you can also modify them yourself.

2. Restart MySQL

After modifying the configuration file, we need to restart the MySQL service for the configuration to take effect.

If it is a Windows system, we can shut down and then start MySQL. The execution command is as follows:

net stop mysql net start mysql

If it is a Linux system, you can directly use the command to restart:

service mysql restart

If it is a Mac system, you can Restart the operation through the interface, as shown in the following figure:

3. Set a new password

After restarting the service, we can set up MySQL through the command line tool New password, first we enter the "mysql -u root -p" command to connect to the MySQL server. When the password input box appears, just hit Enter to log in , as shown in the following figure:

Next we use the following command to set a new password:

update user set password=password('new password') where user='root'; flush privileges; quit

Note

If ERROR 1290 (HY000) occurs when performing this step: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement error. You need to execute the flush privileges command first, and then execute other commands.

Finally

After we set the new password, remember to remove "skip-grant-tables" (skip permission verification) in the MySQL configuration file, and then restart the MySQL service It can be used normally.

More related free learning recommendations: mysql tutorial(Video)

The above is the detailed content of Forgot MySQL password! ? Don't panic~. For more information, please follow other related articles on the PHP Chinese website!