navicat连接centos mysql失败

Can’t connect to MYSQL server on ‘’(10060)

解决

一：开放服务器mysql的默认端口3306

centos7开启方式

firewall-cmd --permanent --zone=public --add-port=3306/tcp

firewall-cmd --reload

二：设置mysql用户远程访问权限

在服务器上连接mysql

use mysql;

select host,user from user;

±----------±-----+
| host | user |
±----------±-----+
| % | root |
| 127.0.0.1 | root |

添加用户：

create user 'username'@'host' identified BY 'password';

删除用户：

delete from user where user='test' and host='localhost';
flush privileges;

授权：

grant privileges ON databasename.tablename TO 'username'@'host'

flush privileges;//刷新系统权限表