Mysql Forgot Password processing configuration

MySQL forgot password processing

1, set the MySQL password

Mysqladmin-uroot Password ' password '

2, the main configuration file to remove the password authorization vim/etc/my.cnf Note: Add skip-grant to cancel the login password authorization. 4, restart MySQL, load configuration file

/etc/init.d/mysqld Restart   #重启mysql

5. Do not use a password to enter MySQL

Mysql-uroot

6. Go to MySQL library, modify user table, change password

# Enter the MySQL library under Mysql>use mysql;# modify the user's password for corresponding users in the user table Mysql>update user set Password=password (' Password ') where user= ' root ';

7, MySQL main configuration file to remove the skip-grant parameters, restart can!

Mysql Forgot Password processing configuration