linux-mysql忘记密码

1.修改mysqld.cnf配置文件

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

在[mysqld]中加入

skip-grant-tables

2.重启mysql

systemctl restart mysql

3.修改密码

mysql -u root

use mysql;

update user set authentication_string=password('新密码'),plugin='mysql_native_password' where user='root';

flush privileges;

exit

4.注释掉mysqld.cnf配置文件添加的skip-grant-tables

5.重启mysql