2018-07-13
问题1：mysql远程连接 Host * is not allowed to connect to this MySQL server
MySQL 8.0 Command Line Client - Unicode
use mysql; select host,user from user where user=‘root‘; update user set host =‘%‘where user =‘root‘;
重启服务使其生效
问题2：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‘;
重启服务使其生效
原文：https://www.cnblogs.com/Ming8006/p/9306452.html