忘記 root 密碼

Anderson

停止   mysql
#service mysqld stop


安全模式
#mysqld_safe --skip-grant-tables &


登入 修改密碼
mysql -u root
mysql> use mysql;
Database changed
mysql> UPDATE user SET Password=PASSWORD("password") WHERE User='root';

Query OK, 3 rows affected (0.02 sec)
Rows matched: 3  Changed: 3  Warnings: 0
mysql> flush privileges;

Query OK, 0 rows affected (0.05 sec)mysql> quit
Bye
重新啟動service mysqld restart

Anderson

停止   mysql
#service mysqld stop


安全模式
#mysqld_safe --skip-grant-tables &


登入 修改密碼
mysql -u root
mysql> use mysql;
Database changed
mysql> flush privileges;
mysql> alter user 'root'@'localhost' identified by '123456';


Query OK, 0 rows affected (0.05 sec)
mysql> quit
Bye

重新啟動service mysqld restart