How can I forget the root password of mysql?
Step 1: (stop running mysql) [root @ CentOs5 ~] # Service mysqld stop
Stopping MySQL: [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 distributionType 'help; 'or' \ H' for help. type' \ C' to clear the buffer. Step 4: Change the user database
Mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-ADatabase 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') where user = 'root ';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0 Step 6: refresh the permission table
Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec) Step 7: Exit mysql
Mysql> quit
Bye Step 8: restart mysql
[Root @ CentOs5 ~] # Service mysqld restart;
STOPPING server from pid file/var/run/mysqld. pid
100421 13:44:03 mysqld endedStopping MySQL: [OK]
Starting MySQL: [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 distributionType 'help; 'or' \ H' for help. type' \ C' to clear the buffer. mysql> quit
Bye