Navicat远程服务器mysql数据库时报错误:2013-Lost connection to MYSQL server at 'reading for initial communicatio

Navicat远程服务器mysql数据库时报错误:2013-Lost connection to MYSQL server at 'reading for initial communicatio

 

解决方案:

开始也改了/etc/my.cnf文件

[mysqldump]
quick
max_allowed_packet = 512M


[mysqld]
port        = 3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
user=mysql
#bind-address=0.0.0.0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


[myisamchk]
key_buffer_size = 1048M
sort_buffer_size = 1048M
read_buffer = 32M
write_buffer = 32M

[mysqlhotcopy]
interactive-timeout

重启了mysql服务,设置了远程连接权限都没有解决

后来查询了mysql的端口改成了3306,关闭了防火墙问题完美解决!

Navicat远程服务器mysql数据库时报错误:2013-Lost connection to MYSQL server at 'reading for initial communicatio