You can connect to your MySQL database remotely using a database client such as HeidiSQL, MySQL Workbench, or via your custom script or application.
Step-by-Step Guide:
1. Allow Your IP in Remote MySQL
- Log in to cPanel.
- Scroll down to the Databases section and click on Remote MySQL.
- Under “Add Access Host”, enter your IP address (you can find it at whatismyip.com).
- Click “Add Host”.
You may use % to allow access from any IP (not recommended for security reasons).
2. Note Your Database Details
- Database Name: Often in the format cpaneluser_databasename.
- Database User: Often in the format cpaneluser_username.
- Database Password: The one you set when creating the user.
- Server/Host: Use your domain name (e.g. yourdomain.com) or server IP address.
3. Connect Using a Client
Example using MySQL Workbench or similar tool:
- Hostname: yourdomain.com or server IP
- Port: 3306 (default)
- Username: cpaneluser_dbuser
- Password: your password
- Database: (optional) enter the database name or select it after connecting
Important Notes:
- Remote MySQL access must be enabled by us. If it fails, please contact support.
- Some firewalls or ISPs may block port 3306 — ensure it's open on your side.
- Use strong passwords and restrict access to specific IPs whenever possible.
