mysql 忘记密码

1/ sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
2/ 在[mysqld]下面添加skip-grant-table
3/ sudo systemctl restart mysql.service
4/ mysql -u root进入mysql
5/ use mysql;
update user set authentication_string=password("qw1234"),plugin='mysql_native_password' where user='root';
退出mysql, 将skip-grant-table变成#skip-grant-table, 重启