MySQL 8.0 忘记密码,重置密码,允许远程访问

vim /init-file.txt

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

systemctl stop mysqld.service 

mysqld --user=mysql --init-file=/init-file.txt --console

 systemctl restart mysqld.service 

mysql -u root -p

use mysql

update user set host='%' where user ='root';

grant all on *.* to 'root'@'%';

flush privileges;