Connecting Remotely to Shared Hosting Databases
The availability of remote database connections depends on which type of hosting account you have. For more information, see What type of hosting account do I have?
|Web Hosting||MySQL: Yes|
|MS SQL (Windows only): Yes|
|MS SQL: Yes|
There are a few stipulations to connecting to databases remotely:
- cPanel accounts must allow remote database management on a per-IP basis. For more information, see Enabling Remote MySQL Management in cPanel.
- If you want to connect to a Web Hosting database remotely, you must enable Direct Database Access when setting it up — you cannot enable it later. For more information, see Why connect remotely to hosting databases? and Creating MySQL or SQL Server Databases for Your Hosting Account.
- Free hosting accounts cannot enable Direct Database Access. To upgrade your hosting account, see Upgrading Your Hosting Account.
- Direct database connections do not support secured (SSL) connections.
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.
Connecting to MySQL Using PHP
Do you restrict any features in MySQL 4.1/5.0?
What version of SQL Server is supported by the Database Publishing Service and Database Publishing Wizard?
What are the new features available in MySQL 4.1?
What are the new features available in MySQL 5.0?
How many simultaneous connections can one MySQL database have?
Your message was successfully sent.
There was an error in sending your message, please try again.
Have a question about the content of this article?