Connecting Remotely to Shared Hosting Databases
|Type||To Enable Remote Database Connections|
|Classic & Web||You must enable Direct Database Access when setting it up — you cannot enable it later. For more information, see Creating MySQL or SQL Server Databases for Your Hosting Account.1|
|cPanel||See Enabling Remote MySQL Management in cPanel.|
|Plesk||Remote database connections for both MySQL and MS SQL are enabled by default.|
NOTE: Direct database connections do not support secured (SSL) connections.
1 Free Web Hosting accounts cannot enable Direct Database Access. To upgrade your hosting account, see Upgrading Your Hosting Account.
How to Connect Remotely
All of these applications use similar settings. You can find your database's specific settings in Viewing Your Database's Details.
- Host Name or Server — Your database's host name.
- Port — If asked for the port, enter the following depending on the type of database you're connecting to:
MySQL 3306 MS SQL 1433
- User Name — Your database's user name.
- Password — Your database's password. If you've forgotten it, you can edit it from the database's Details page by clicking Reset.
- Database — Your database's user name.
Do you restrict any features in MySQL 4.1/5.0?
What are the new features available in MySQL 4.1?
How many simultaneous connections can one MySQL database have?
What are the new features available in MySQL 5.0?
What are the major differences between MySQL 4.0 and 4.1/5.0?
What is MARS and how do I use it?