1.先停掉mysql
# /etc/init.d/mysql stop
2.以–skip-grant-table 的參數啟動mysql
# /usr/bin/mysqld_safe –skip-grant-table&;
3. 更改root 密碼
# mysql -u root
mysql> use mysql;
mysql> UPDATE user SET password=password(‘新的密碼’) WHERE user=’root’;
mysql> exit;
4.停掉mysql再重跑
# /etc/init.d/mysql stop
# mysql -u root -p
Enter password: //輸入新設定的密碼