Can I remote access to our MySQL database ? Print

Yes, you can remotely access your 4GoodHosting MySQL database (which uses cPanel), but you’ll need to follow several steps to ensure it works securely.

 How to Set It Up in cPanel (4GoodHosting)

1. Whitelist your IP address

   • Log in to your cPanel.

   • Go to Databases → Remote MySQL (or Remote Database Access).

   • Under “Add Access Host,” enter your current IP (you can find it via “what is my IP” online). Use % instead of an IP to allow all IPs, though that’s less secure.

   • Click Add Host. stackoverflow.com+14kb.hosting.com+14inmotionhosting.com+14hostgator.comgodaddy.com+3inmotionhosting.com+3cpanel.net+3

2. Ask support to open port 3306 (if needed)

   • Some shared hosts block MySQL’s default port for security.

   • Submit a support ticket requesting inbound access to port 3306 and mention your account needs it. stackoverflow.comkb.hosting.com+1kb.hosting.com+1

3. Use a MySQL client to connect

   • Use MySQL Workbench, HeidiSQL, or similar.

   bash

    

   mysql -u your_db_user -p -h your_cpanel_server -P 3306 your_database_name

   • It’ll prompt for your password. phoenixnap.com+13stackoverflow.com+13hostgator.com+13knownhost.com+1inmotionhosting.com+1