MySQL 5.7 - 忘記 root 密碼

停止 MySQL 之後增加 skip-grant-tables 到 my.cnf [mysqld] 區域

# systemctl stop mysqld
# vi /etc/my.cnf
[mysqld]
skip-grant-tables

# systemctl start mysqld

# systemctl stop mysqld

# vi /etc/my.cnf

[mysqld]

skip-grant-tables

# systemctl start mysqld

進入 MySQL 後設定 root 新密碼

# mysql -u root -p
use mysql;
update mysql.user set authentication_string=password('new password') where user='root';
flush privileges;

# mysql -u root -p

use mysql;

update mysql.user set authentication_string=password('new password') where user='root';

flush privileges;

將 my.cnf skip-grant-tables 設定移除，重新啟動 MySQL

# vi /etc/my.cnf
# systemctl restart mysqld

1 2	# vi /etc/my.cnf # systemctl restart mysqld

218 total views, 1 views today