Bluehost Web Hosting Help
Remote Database Connection Setup
See our article on Managing Your Database with Applications for some suggested programs and more details.
Use the following configuration settings for connecting to your database
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306
TCP or UDP, either is fine.
Allowing a Remote Server to Access Your Database
Before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.
- Log into cPanel and click the Remote MySQL icon, under Databases.
- Type in the connecting IP address, and click the Add Host button.
- Note: You can find and add your IP address directly from this tool. Look for Your IP is: 18.104.22.168 [Add]. Clicking the [Add] link will input your IP into the field box below.
- Click Add, and you should now be able to connect remotely to your database.
Removing Access for a Remote Server to Access Your Database
To remove a host from accessing databases on your server:
- Click the X icon next to the IP address.
- If you are sure you wish to prevent the server from accessing your databases, click Yes.
Dynamic IP Addresses
Having a dynamic IP address means that the connecting IP address can change periodically depending on the Internet Service Provider (ISP). You must update the connecting IP in Remote MySQL every time it changes.
Managing Your Databases
After whitelisting the IP to allow remote connection, you should be able to make the proper remote MySQL connection with the database's name and user found in the cPanel's MySQL Databases page. The most common problem in connecting is due to an incorrect username and/or password. Please make sure the username you use matches the username created in the "MySQL Database" section of your cPanel. For examples of MySQL errors, please see the related article: MySql Errors
Recommended Help Content
MySQL Database and user name convention
I cannot connect to my database locally or remotely, do I have the correct server, username and password? (updated 1960 days ago)
Local MySQL Connection Blocked To Server
I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.BlueHost.com' is blocked because of many connection errors; unblock with 'mysqlad (updated 61 days ago)
Managing Databases with Applications
This article will go over different application available for remote connection to your databases. (updated 890 days ago)
Related Help Content
Whitelist IP Address
How do I Whitelist my IP Address? I can't log into MySQL from a remote computer using a MySQL admin tool (phpMyAdmin, Navicat, MySQLFront, MySQL-Admin, etc). (updated 1014 days ago)
FTP Setup Using CuteFTP Home Version 8.2
How do I setup CuteFTP 8.2 for FTP? (updated 1102 days ago)
Connecting to your MySQL DB from Dreamweaver
How can I connect to our MySQL database from Dreamweaver? (updated 1099 days ago)
FTP Connection Drops
Why does the FTP connection keep dropping before the transfer completes? (updated 1664 days ago)
MySQL Connection Strings
This article will describe connections strings, what they are used for, and give examples. (updated 518 days ago)
Connecting Scripts to MySQL Databases
This article will explain how to connect your scripts to your MySQL databases. (updated 885 days ago)
How can I remotely access my e-mail?
How can I remotely access my e-mail? (updated 582 days ago)
How to Create and Delete MySQL Databases and Users
This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 119 days ago)