Remotely connect to SQL
Connection parameters
| Parameter | Value |
|---|---|
| Host | YOURDOMAIN.COM |
| Database name | cpanelusername_databasename |
| Database username | cpanelusername_databaseuser |
| Database password | ****** |
| MySQL Connection Port | 3306 |
| Protocol | TCP |
Before connecting to MySQL from your computer, you need to register it in cPanel as authorized access.
Steps
- Enter cPanel and click on the MySQL remote option, within Databases.
- Type your IP (or use
%as a wildcard e.g. 123.123.123.%) and click Add Host. - Everything ready, try to connect remotely.
Recommended readings
Still need help?
If this guide didn’t solve your issue, our team can help you via ticket.