1、vim /etc/my.cnf,添加 skip-grant-table(跳过权限验证)
/etc/mysql/mysql.conf.d/mysqld.cnf
sudo systemctl restart mysql
2、flush privileges
3、mysql -uroot -p
先把root的旧密码置空 use mysql; update user set authentication_string='' where user='root';
先把root的旧密码置空
use mysql;
update user set authentication_string='' where user='root';
备注:Mysql5.7+ password字段 已改成 authentication_string字段
先把root的旧密码置空
use mysql;
update user set authentication_string='' where user='root';
备注:Mysql5.7+ password字段 已改成 authentication_string字段
重置成新密码
alter user 'root'@'localhost' identified by 'newpassword';
备注:Mysql8.0修改密码方式已有变化(此处是个坑,需要注意)
Mysql8.0之前:
update user set password=password('root') where user='root';