为何部分服务器连接MySQL被拒绝？远程数据库连接异常求助

Hey there, let's tackle this connection issue step by step—since you've already whitelisted your iPage host but still get a "connection refused" error, here are the most likely fixes to check:

1. Double-Check the Whitelist Entry #

• First, confirm you're using the correct public IP address of your iPage virtual host. Shared hosts often use dynamic IPs, or you might have added the wrong one. To get your iPage server's public IP, log into your iPage cPanel and look for "Server Information" or run this command via SSH (if available):

  curl ifconfig.me
  

• Also, some MySQL servers require you to whitelist the IP with a wildcard (like x.x.x.x/24) instead of a single IP, especially if iPage uses a range of IPs for their shared hosts. Check your remote MySQL host's cPanel "Remote MySQL" section—make sure the entry matches exactly, or try the broader range.

2. Verify MySQL Port Access #

• By default, MySQL uses port 3306. Ensure your remote MySQL server isn't blocking this port for incoming connections from iPage's IP range. Some shared hosts restrict outbound ports too—check iPage's documentation to confirm port 3306 is allowed for outbound traffic.
• You can test port connectivity from your iPage host using telnet or nc (if available):

  nc -zv your-remote-mysql-ip 3306
  

  If this fails, it's a port blocking issue—either on the remote MySQL side or iPage's firewall.

3. Check MySQL User Permissions #

• Even if the IP is whitelisted, the MySQL user you're using might not have permission to connect from your iPage host. Make sure the user is created with '%' (any host) or specifically your iPage server's IP. For example, in phpMyAdmin or via SQL command:

  GRANT ALL PRIVILEGES ON your_database.* TO 'your_user'@'iPage-server-ip' IDENTIFIED BY 'your_password';
  FLUSH PRIVILEGES;
  

• Don't forget to replace iPage-server-ip with the actual public IP of your iPage host, or use '%' if you want to allow connections from anywhere (though less secure).

4. Confirm Remote MySQL is Enabled #

• Some cPanel shared hosts disable remote MySQL connections by default. Log into your remote MySQL host's cPanel, go to "Remote MySQL" (under Databases), and ensure the feature is turned on. Sometimes there's a toggle or a note saying "Remote connections allowed"—if not, you might need to contact your host's support to enable it.

5. Test for DNS Resolution Issues #

• On your iPage host, try pinging your remote MySQL server's hostname to see if it resolves to the correct IP:

  ping your-remote-mysql-hostname
  

  If the IP doesn't match what you whitelisted, you might have a DNS cache issue or an incorrect hostname. Try using the direct IP address instead of the hostname in your WordPress wp-config.php to rule this out.

6. Check Firewall Settings on Both Ends #

• Your remote MySQL host might have a server-level firewall (like CSF/LFD) that's blocking the connection even if cPanel's Remote MySQL is configured. Contact your remote host's support to check if their firewall is allowing traffic from iPage's IP on port 3306.
• iPage's shared host firewall might also be blocking outbound connections to port 3306. Reach out to their support to confirm this isn't the case—sometimes shared hosts restrict certain ports to prevent abuse.

内容的提问来源于stack exchange，提问作者SaFi2266