Connecting Remotely to Shared Hosting Databases
If you want to connect remotely to the database on your shared hosting account (more info), how you enable it depends on the type of hosting you have (more info).
| Type | To Enable Remote Database Connections |
|---|---|
| Classic & Web | You must enable Direct Database Access when setting it up — you cannot enable it later (more info).1 |
| cPanel | Remote connections are supported but must be enabled (more info). |
| Plesk | Remote database connections for both MySQL and MS SQL are enabled by default. |
1 Free Web Hosting accounts cannot enable Direct Database Access. To upgrade your hosting account, see Upgrading Your Hosting Account.
NOTE: Direct database connections do not support secured (SSL) connections.
How to Connect Remotely
To remotely connect to your database, you need to use database management software such as MySQL Query Browser, MySQL Workbench, or Microsoft SQL Server Management Studio Express.
Application Settings
Applications that connect remotely to databases use similar settings. You can find database's specific information using Viewing Your Database Details with Shared Hosting Accounts.
| Field | What to enter... |
|---|---|
| Host Name or Server | Your database's host name |
| Port | MySQL: 3306 MS SQL: 1433 |
| Username | The database user's username |
| Password | The database user's password |
| Database | The name of the database (for Web & Classic hosting, this is the same as the username) |