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,关闭了防火墙问题完美解决!