預防下次又忘記密碼...

MySQL root 密碼忘了，可按照下列方式更正:
1.先停掉mysql
# /etc/rc.d/init.d/mysqld stop
2.以--skip-grant-table 的參數啟動mysql
#/usr/bin/mysqld_safe --skip-grant-table& (執行完會進入背景)
3. 更改root 密碼
# mysql mysql
mysql> UPDATE user SET password=password('newpassword')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> exit
4.停掉mysql再重跑
# /etc/rc.d/init.d/mysqld stop
# /etc/rc.d/init.d/mysqld start
# mysql –u root -p
Enter password: //輸入新設定的密碼

12

「Wish you all the best」 Thanks a lot ！！
Spyware Doctor 2010 7.0
Name:： weiquan wang
S/N:： CE0A-9FB1-8814-EF19-03ED-0AA5-2E84-A854-0CE2-6E84