How to solve the problem of forgetting mysql password

The solution for mysql forgotten password: first find the "my.ini" file; then add "skip-grant-tables" under "mysqld"; then restart the mysql service; finally reset the password through update. Can.

#The operating environment of this article: Windows 7 system, Dell G3 computer, MySQL Server 5.7.

What should I do if I forget mysql password?

When we install and use MySQl, sometimes we may inevitably forget the password. If you forget the password, you can follow the following plan:

• Find my. ini file
  The my.ini file is the MySQl setting file. If you are at the default installation address, the file is under
  C:\ProgramData\MySQL\MySQL Server 5.7
  But ProgramData is hidden in normal state

• Set permission authentication skip
  That is, add skip-grant-tables under [mysqld]

   skip-grant-tables

Restart the mysql service

Here you can directly enter continuously in the command line or find the mysql service in the service to restart

 	net stop mysql
 	net start mysql

After restarting, log in with mysql -uroot -p
and you will find that we can log in without a password

    mysql -uroot -p

• Reset password
  

First select the mysql database

   use mysql

Then update the password

   update user set authentication_string = password ( 'new-password' ) where user = 'root' ;

Note: What needs to be changed here is the authentication_string. Instead of password field
, if you enter

   update user  set Password=password('new-password') where user='root'

, an error will be reported: ERROR 1054 (42S22): Unknown column 'password' in 'field list';

The reason is mysql There is no password field in the database anymore. The password field has been changed to authentication_string

• Remove the added skip- in the my.ini file grant-tables
  

• Restart mysql service
  

• Log in with new password
  

Recommended study: "mysql video tutorial"

##

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