Linux forgot MySQL password processing method:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> Update user Set Password=password (' NewPassword ') where user= ' root ';
mysql> flush Privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql>
The modified user is in the column root.
First, the original myql of the root of the password;
Method One:
Outside the MySQL system, use the Mysqladmin
# mysqladmin-u root-p Password "test123"
Enter Password: "Enter the original password"
Method Two:
By logging in to the MySQL system,
# mysql-uroot-p
Enter Password: "Enter the original password"
Mysql>use MySQL;
mysql> Update user Set Password=password ("test") where user= ' root ';
mysql> flush Privileges;
Mysql> exit;
Method Three:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql> Grant all on *.* to root@ '% ' identified by ' password ';
Method Four:
Use the username and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>
Mysql>
Second, forget the original myql of the root password;
First, you have to have the operating system root permissions. If you don't have root access to the system, consider the root system and then follow the steps below.
Similar to the Safe Mode login system, it is suggested that Pkill MySQL, but I do not recommend Kazakhstan. Because when you execute this command, it can lead to a situation like this:
/ETC/INIT.D/MYSQLD status
Mysqld dead but Subsys locked
So even if you are in Safe mode to start MySQL may not be useful, so generally it is so/etc/init.d/mysqld stop, if you unfortunately first used Pkill, then start to stop again.
# Mysqld_safe--skip-grant-tables &
To run in the background, no longer running in the background, then open a terminal slightly.
# MySQL
mysql> use MySQL;
mysql> UPDATE user SET Password=password ("test123") WHERE user= ' root ';
mysql> flush Privileges;
Mysql> exit;
# #本来mysql是不分大小写的, but this is the specific value of the MySQL database modified in MySQL, to be noted.