Problem with Remote mysql

lifesecond

• March 04, 2017 04:49

Hello, I'm new here and sorry for my English...:) I want to connect to the database of cPanel from another host. I added the host access ('%') but when I try to connect to it, the browser show me this error: "Warning: mysql_connect (): Unable to establish connection. Incorrect response of the connected parties after the interval or failure response from the host is connected." Does anyone know what I have to do to connect properly? Thanks in advance, Life

• 

  Jcats

  • March 04, 2017 14:03

  You need to speak with both hosts, most hosts by default will block access to port 3306 to prevent attacks. Do you have SSH access? You can try to connect using SSH to test:
  # mysql -u $dbuser -p $dbname -h $remoteserver
  hit enter, it will ask for the db user password, enter it in, then see what happens, it will most likely timeout which would mean a firewall issue.

  0
• 

  lifesecond

  • March 04, 2017 14:34

  You need to speak with both hosts, most hosts by default will block access to port 3306 to prevent attacks. Do you have SSH access? You can try to connect using SSH to test:
  # mysql -u $dbuser -p $dbname -h $remoteserver
  hit enter, it will ask for the db user password, enter it in, then see what happens, it will most likely timeout which would mean a firewall issue.

  
  I don't have SSH access....o_O but the documentation of cPanel (Host text box. Notes: [LIST]

  You may enter a fully qualified domain name (FQDN) or an IP address.

  You may use the percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 192.68.0, enter 192.68.0.%.

  Click Add Host. Why if I follow these steps I can't connect? I don't understand...:confused:

  0
• 

  Jcats

  • March 04, 2017 16:54

  Because that has no control over your host's firewall, if they block access to port 3306 then although doing what the documentation says is needed, its irrelevant in the sense that the connection isn't being allowed by the firewall. So my suggestion remains.

  You need to speak with both hosts, most hosts by default will block access to port 3306 to prevent attacks.

  
  

  0
• 

  cPanelMichael

  • March 06, 2017 15:08

  Hello, You'll need to check with your hosting provider to verify access over port 3306 is permitted, as mentioned in the previous post, as it's possible your hosting provider is blocking the port in the system firewall rules. Let us know the outcome. Thank you.

  0

Please sign in to leave a comment.