一、配置mysql的配置文件my.cnf
vim /etc/my.cnf
#在[mysqld]部分添加如下一行字符
default_authentication_plugin = mysql_native_password
二、登录mysql,重新创建root账号:
#先刷新权限
flush privileges;
#创建用户
CREATE USER 'root'@'localhost' IDENTIFIED BY 'password';
#赋予权限
GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';
#刷新权限
flush privileges;
#创建用户
CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY 'password';
#赋予权限
GRANT ALL PRIVILEGES ON * . * TO 'root'@'127.0.0.1';
#刷新权限
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '123456';
#退出mysql操作
quit;
三、重启mysql服务:
systemctl restart mysqld;
四、重新登录phpMyAdmin,发现可以登录成功了: