How to Connect to Your Database Remotely (Remote MySQL)

By default, your dotCanada MySQL databases only accept connections from the server itself. If you want to connect from your local computer - using a tool like TablePlus, Sequel Pro, or DBeaver - you'll need to whitelist your IP address using cPanel's Remote MySQL feature.

Adding Your IP Address

1. Log in to cPanel.
2. Go to Databases > Remote MySQL.
3. Enter your local machine's IP address in the Host field. You can find your IP at whatismyip.com.
4. Click Add Host.

Connecting with a Database Client

Once your IP is whitelisted, use the following connection details in your database client:

• Host: Your domain name or server IP (not localhost)
• Port: 3306
• Username: Your database username (created in MySQL Databases)
• Password: Your database user's password
• Database: Your database name

Security Considerations

• Only whitelist IP addresses you actively need to connect from.
• Remove old or unused IP entries from Remote MySQL to minimize exposure.
• Consider using SSH tunneling for an extra layer of security when connecting remotely.

Connecting via SSH Tunnel

For a more secure connection, tunnel through SSH: ssh -L 3307:localhost:3306 username@yourdomain.com. Then connect your database client to localhost:3307.

If you have trouble connecting remotely, contact our support team and we'll help you get connected.