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 allow access from any IP address(es) you will be connecting to MySQL/MariaDB from. Here are the steps to do so:

1. Open the "Remote Database Access" page in the account's cPanel that has the database(s) you want to allow remote access to.
2. Under "Add Access Host", you will want to add the IP under "Host (% wildcard is allowed)".
3. Click the "Add Host" button.

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:

Remote MySQL®