MySQL数据库的安装教程及相关问题

2018-07-13

问题1：Authentication plugin 'caching_sha2_password' cannot be loaded

alter user 'root'@'%' identified with mysql_native_password by 'root';
set password for 'root'@'%'='Test123';
--Test123 为密码 root为user %对应host，默认是localhost，%是通配符 
flush privileges;

问题2：mysql远程连接 Host * is not allowed to connect to this MySQL server

MySQL 8.0 Command Line Client - Unicode

use mysql;
select host,user,plugin from user where user='root'; 
update user set host ='%'where user ='root';

重启服务使其生效

+-----------+------------------+-----------------------+
| Host      | User             | plugin                |
+-----------+------------------+-----------------------+
| %         | ming8006         | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | caching_sha2_password |
+-----------+------------------+-----------------------+

问题3：navicat 连接 mysql 出现1251Client does not support authentication protocol requested by server的解决方案

MySQL 8.0 Command Line Client - Unicode

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'quark@123';

重启服务使其生效