How to access MySQL Remote from Cpanel

1

How do I access the Cpanel MySQL database? I have already entered the wildcard host% in the list of allowed hosts, but when trying to access this error message appears:

  

Error # 2003   Can not connect to MySql server on 'ServerHost.com' (10060).

I also tried to insert the IP of my machine in the list of hosts, but I have the same result.

Thank you in advance.

    
asked by anonymous 10.02.2017 / 19:24

1 answer

0

cPanel may have been configured to allow connection, but there may be a Firewall that is blocking access to the outside port.

Test:

  

telnet hostname.com 3306

If a connection or timeout error occurs, it is very likely that a firewall will prevent access. In that case you should contact the provider. If it works and appears mysql access can be a problem with user privileges. Access the phpMyAdmin from cPanel, choose the database, then Privileges or Users and verify that the user you are trying to use has outside access (eg 'username' @ '%').

    
10.02.2017 / 19:31