Connecting Remotely to Shared Hosting Databases
To connect remotely to a database, you must create a database and enable direct database access. If a database was created without this option selected, you will not be able to connect remotely.
For more information on creating a database with direct database access, see Setting up a MySQL or SQL Server Database for Your Hosting Account
To use Direct Database Access to connect remotely to your shared hosting database, you need to download software that lets you connect to the database and manage it.
NOTE: Direct Database Access is not available on free ad-supported hosting accounts. To upgrade your hosting account, see Upgrading Your Hosting Account.
Some popular database management applications are:
After downloading and installing one of these clients, you can use it to connect to your database. These are your connection settings:
- Host Name or Server
- The name of the server your database is stored on. Don't know what this is? See What do I use for a host name when creating a database? for more information.
- Port
- If asked for the port, enter the following:
- MySQL: 3306
- MSSQL: 1433
- User Name
- The database's user name.
- Password
- The database's password. The password is created when the database is first set up but can be changed at any time.
- Database
- The database you want to connect to.
NOTE: You can log in to your hosting account manager to find the hostname, user name, and password for your database.
Related Material
Setting up a MySQL or SQL Server Database for Your Hosting AccountWhy Connect Remotely to Shared Hosting Databases