Why am I unable to connect to a MySQL database remotely?

Question

Why am I unable to connect to a MySQL database remotely?

Answer

You will need to add any IP address you will be connecting to MySQL from to the Access Hosts list in cPanel >> Databases >> Remote MySQL. This interface controls which remote hosts are allowed to connect to databases on the cPanel account remotely.

You will also need to ensure that MySQL is configured to listen publicly:

How to configure MySQL / MariaDB to listen publicly so that remote connections will work

Further information on Remote MySQL can be found in our documentation here.