博客

#在配置文件mysqld.cnf下添加 skip-grant-tables

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

重启MySQL服务

sudo service mysql restart

登录MySQL

mysql -u root -p

选择管理user表的数据库

use mysql;

authentication_string 置空

update user set authentication_string=‘’ where user=‘root’;

plugin改为以前版本的密码认证方式

update user set plugin=‘mysql_native_password’ where user=‘root’;

FLUSH PRIVILEGES;

alter user ‘root’@‘localhost’ identified by ‘newpassword’;

service mysql restart