How to retrieve the password of the root user missing from the MySQL database in CentOS Linux

In Centos linux, mysql forgets the password of the root user: Step 1: (stop running mysql) [root @ CentOs5 ~] # ServicemysqldstopStoppingMySQL: [OK] Step 2: Use the "-- skip-grant-tables" parameter to restart mysql [root @ CentOs5 ~] # Mysql

Centos linuxMysqlForget the root user password:

Step 1: (stop running mysql)
[Root @ CentOs5 ~] # Service mysqld stop
StoppingMySQL:                                          [OK]

 

Step 2: Use the -- skip-grant-tables parameter to restart mysql
[Root @ CentOs5 ~] # Mysqld_safe -- skip-grant-tables &
[1] 23810
[Root @ CentOs5 ~] # Starting mysqld daemon with databases from/var/lib/mysql

 

Step 3: log on to mysql with an account
[Root @ CentOs5 ~] # Mysql-u root
Welcome to the MySQL monitor.Commands end with; or \ g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution

Type 'help; 'or' \ H' for help. Type '\ C' to clear thebuffer.

 

Step 4: change the user database
Mysql> use mysql
Reading table information for completion of table and columnnames
You can turn off this feature to get a quicker startup with-

Database changed

 

Step 5: change the password. remember to use the password () function to encrypt the password. do not forget it !!!
Mysql> update user set password = password ('admin123') whereuser = 'root ';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1Changed: 1Warnings: 0

 

Step 6: refresh the permission table
Mysql> flush previleges;
ERROR 1064 (42000): You have an error in your SQL syntax; check themanual that corresponds to your MySQL server version for the rightsyntax to use near 'previleges' at line 1
Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

 

Step 7: Exit mysql
Mysql> quit
Bye

 

Step 8: restart mysql
[Root @ CentOs5 ~] # Servicemysqld restart;
STOPPING server from pid file/var/run/mysqld. pid
13:44:03 100421Mysqld ended

StoppingMySQL:                                          [OK]
StartingMySQL:                                          [OK]
[1] +Done                  Mysqld_safe -- skip-grant-tables

 

Step 9: log on again with the changed password.
[Root @ CentOs5 ~] # Mysql-u root-p
Enter password: admin123
Welcome to the MySQL monitor.Commands end with; or \ g.
Your MySQL connection id is 2
Server version: 5.0.77 Source distribution

Type 'help; 'or' \ H' for help. Type '\ C' to clear thebuffer.

Mysql> quit
Bye
[Root @ CentOs5 ~] #