標籤：
Centos系統mysql 忘記root使用者的密碼：
第一步：(停掉正在啟動並執行mysql)
[[email protected] ~]# /etc/init.d/mysqldstop
StoppingMySQL: [ OK ]
第二步：使用 “--skip-grant-tables”參數重新啟動mysql[[email protected] ~]# cd 到mysql目錄，這裡到bin目錄，會提示“Please do a cd to the mysql installation directory and restart”
[[email protected] ~]# ./bin/mysqld_safe--skip-grant-tables
[[email protected] ~]# Starting mysqld daemon withdatabases from /var/lib/mysql
注意：如果停在這一步的時候，請複製一個新的會話接著下一步操作
第三步：用帳號登入mysql
[[email protected] ~]# 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.
第四步：改變使用者資料庫
mysql> use mysql
Reading table information for completion of table and columnnames
You can turn off this feature to get a quicker startup with-ADatabase changed
第五步：修改密碼，下面()內的root123為新密碼
mysql>update user set password=password(‘root123‘) whereuser=‘root‘;
Query OK, 3 rows affected (0.00sec)Rows matched: 3 Changed: 3 Warnings:0
第六步：重新整理許可權表
mysql> flush privileges;
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
mysql> quit
Bye
第八步：對mysql進行重啟
[[email protected] ~]# /etc/init.d/mysqldrestart;
StoppingMySQL: [ OK ]
StartingMySQL: [ OK ]
第九步：用更改過的密碼重新登入即可。
[[email protected] ~]# 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
[[email protected] ~]#
加入如下自動啟動命令 /etc/rc.d/init.d/mysqld start
轉載：http://blog.sina.com.cn/s/blog_4488002e0100z574.html
參考：http://blog.chinaunix.net/uid-25266990-id-2921603.html
Centos系統mysql 忘記root使用者的密碼
