| MySQL root密码忘记的解决方法 |
| 1.先停掉mysql # /etc/rc.d/init.d/mysql stop 2.以--skip-grant-table 的參數啟動mysql # mysql_safe --skip-grant-table& 3. 更改root 密碼 123456 # mysql mysql mysql> UPDATE user SET password=password('123456') WHERE user='root'; mysql> FLUSH PRIVILEGES; mysql> exit 4.停掉mysql再重跑 killall mysqld #/etc/rc.d/init.d/mysqld # mysql -u root -p Enter password: |