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
- Log in at https://tpc-hosting.com/login and open cPanel.
- Under Databases, click Remote MySQL.
- 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.
- Click Add Host.
- 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.