centos7 mysql8 设置远程访问遇到的问题
如果查看的教程https://blog.csdn.net/lihao21/article/details/80692068
首先可以 更改/etc下的my.cnf和运行以下代码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
flush privileges;
如果运行以上命令还是报error,