How to Allow Remote MySQL Connections in cPanel

Knowledgebase / How to Allow Remote MySQL Connections in cPanel

How to Allow Remote MySQL Connections in cPanel

0 found helpful (0 votes) ...
Back to Knowledgebase

By default, MySQL on your hosting account only accepts connections from the server itself (localhost). To connect to your database from an external application, a remote server, or your local development machine, you need to whitelist that IP address.


Add a remote access IP address

  1. Log in at https://tpc-hosting.com/login and open cPanel.
  2. Under Databases, click Remote MySQL.
  3. In the Host field, enter the IP address of the machine that needs remote access. This must be the public IP of the connecting machine — not a local/private IP like 192.168.x.x.
  4. Click Add Host.
  5. The IP now appears in the list of allowed remote hosts.

Connect remotely

Use these connection details in your application or MySQL client (e.g., TablePlus, DBeaver, MySQL Workbench):

  • Host: your domain name or server IP address
  • Port: 3306 (default MySQL port)
  • Database: the full database name (format: cpanelusername_databasename)
  • Username: the full database username (format: cpanelusername_username)
  • Password: the database user password set in cPanel → Databases → MySQL Databases

Remove remote access

On the Remote MySQL page, click Delete next to an IP to revoke its access. Remove IPs you no longer need — open remote access increases your attack surface.


Security notes

  • Only whitelist specific IPs, not ranges. Avoid using % (wildcard) as the host — this allows any IP to attempt a connection.
  • Use strong passwords for all database users with remote access.
  • Consider using an SSH tunnel instead of direct remote MySQL access for sensitive data — this encrypts the connection without exposing port 3306.

Was this article helpful?



Still need help?

Open a support ticket →

On This Page