mysql root password recovery

忘了mysql的root密碼, 要重設一個
基本上就是把mysql server啟動在一個跳過密碼檢查的狀態下
登入mysql server, 重設一個root的密碼
再把mysql server正常啟動
------------------------------------------
Start MySQL Server without password:
# mysqld_save --skip-grant-tables &

Login MySQL Server as root:
# mysql -u root

Setup new password for root:
mysql> use mysql;
mysql> update user set password=PASSWORD("new-password-for-root") where User='root';
mysql> flush privileges;
mysql> quit

Start MySQL Server Normally:
# service mysqld start

當然是要把先前啟動的mysql server停下來後, 再重新啟動

Ref. Link --> http://www.cyberciti.biz/tips/recover-mysql-root-password.html