远程服务器CentOS7安装MySQL并用本地Navicat连接

1.CentOS7安装MySQL

https://www.cnblogs.com/bigbrotherer/p/7241845.html

 

2.Navicat连接远程数据库

报错：Host 'xxx' is not allowed to connect to this MySQL server.

解决：

update user set host = '%' where user = 'root';

参考： https://www.cnblogs.com/vathena/p/4012399.html

 

使用以上两个步骤，安装MySQL成功，并使用Navicat成功连上远程数据库。