mysql - cPanel Mysql 远程连接错误 2003 (HY000)

Question

Mysql 服务器在共享主机上运行没有任何问题。
PHP 工作正常，连接到 mysql 并通过 apache 很好地服务站点。cPanel 工作没有任何问题。

转到特定帐户的 cPanel 并添加到“Remote MySql”远程主机 IP，当这不起作用时，使用通配符来允许任何人连接 ('%')。

my.cnf 内容:

[mysqld]
local-infile=0

max_connections=200
table_open_cache=256
max_delayed_threads=20
max_tmp_tables=32
query_cache_type=1
query_cache_size=4M
thread_cache_size=4
innodb_file_per_table=1
open_files_limit=30428
max_allowed_packet=268435456
bind-address = x.x.x.x

innodb_buffer_pool_size=8M
[mysqldump]
events

注意:尝试了绑定(bind)地址中的 0.0.0.0 以及我服务器的主要和辅助 IP。也尝试过没有任何绑定(bind)地址

尝试连接时的 tcpdump 输出:

#tcpdump -i any port 3306
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on any, link-type LINUX_SLL (Linux cooked), capture size 65535 bytes
16:52:24.382293 IP x.x.x.x.59222 > x.x.x.x.mysql: Flags [S], seq 4293479800, win 29200, options [mss 1380,sackOK,TS val 4646672 ecr 0,nop,wscale 7], length 0
16:52:25.379861 IP x.x.x.x.59222 > x.x.x.x.mysql: Flags [S], seq 4293479800, win 29200, options [mss 1380,sackOK,TS val 4646922 ecr 0,nop,wscale 7], length 0
16:52:27.383794 IP x.x.x.x.59222 > x.x.x.x.mysql: Flags [S], seq 4293479800, win 29200, options [mss 1380,sackOK,TS val 4647423 ecr 0,nop,wscale 7], length 0
16:52:31.387599 IP x.x.x.x.59222 > x.x.x.x.mysql: Flags [S], seq 4293479800, win 29200, options [mss 1380,sackOK,TS val 4648424 ecr 0,nop,wscale 7], length 0
16:52:39.403709 IP x.x.x.x.59222 > x.x.x.x.mysql: Flags [S], seq 4293479800, win 29200, options [mss 1380,sackOK,TS val 4650428 ecr 0,nop,wscale 7], length 0
16:52:55.419900 IP x.x.x.x.59222 > x.x.x.x.mysql: Flags [S], seq 3596828352, win 29200, options [mss 1380,sackOK,TS val 4654432 ecr 0,nop,wscale 7], length 0
6 packets captured
6 packets received by filter
0 packets dropped by kernel

IPTABLE 规则

Chain INPUT (policy DROP 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         
    0     0 ACCEPT     tcp  --  all    any     anywhere             anywhere            tcp dpt:mysql 
  36M 6414M acctboth   all  --  any    any     anywhere             anywhere            
    0     0 ACCEPT     tcp  --  !lo    any     ns5.servint.net      anywhere            tcp dpt:domain 
    0     0 ACCEPT     udp  --  !lo    any     ns5.servint.net      anywhere            udp dpt:domain 
    0     0 ACCEPT     tcp  --  !lo    any     ns5.servint.net      anywhere            tcp spt:domain 
....

netstat 输出

#netstat -nat |grep :3306
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN  

还是没有运气。无法连接Mysql，出现同样的错误:

错误 2003 (HY000):无法连接到“x.x.x.x”(110) 上的 MySQL 服务器

Answer 1

这可能过于简单化了，但是你重启过Mysql吗？

您的错误与配置中没有绑定(bind)地址的配置一致，但我确实看到了您的错误。我只是想知道自您编辑配置以来是否已加载配置: ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

此外，您是否在为 Mysql 用户配置远程访问的 Cpanel 中尝试使用实际 IP 地址而不是通配符进行测试？

希望这会有所帮助!