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

2018-07-13

MySQL数据库的下载及安装教程

问题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‘;

重启服务使其生效