Bluehost Web Hosting Help
Managing Databases with Applications
There are many applications that can be installed on your computer for managing your databases. Here are some suggested applications you may use for that purpose. These applications are supplied by third parties. Some are free and some require you to purchase a license.
The database management program (application) that you choose depends on what type of database you are connected to. All our web hosting plans offer MySQL.
For MySQL, if you do not want to use a desktop application, you can use phpMyAdmin in cPanel to manage your database, which can be accessed with a web browser.
Download the Application
Download one of these applications:
- MySQL Workbench from Oracle / MySQL (free or commercial)
- EMS SQL Manager for MySQL (free or commercial)
- EMS SQL Management Studio for MySQL (commercial)
- Navicat (MySQL GUI) (commercial)
- urSQL (shareware)
The applications above are designed for managing databases. Some web development software, like Dreamweaver, can also connect to MySQL remotely. Many other applications are available and can be found by using a search engine.
Whitelisting Your IP
To connect remotely, you will need to whitelist your IP address.
- Login to your Bluehost Control Panel and click the Remote MySQL icon, under Databases.
- At the top of the page your IP Address and your C class are listed. To whitelist just your IP Address click the "[Add]" text to add your IP address.
- You should now be able to connect remotely.
Recommended Reading: How to connect to the MySQL database
Connecting
How you connect will depend on which program you pick. The website where you downloaded the applications should have instructions on how to connect and use their application.
Recommended Help Content
How To Setup Remote Database Connection - Configure MySQL client Access
How do I remotely connect using a database management software?
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.
Connecting Scripts to MySQL Databases
This article will explain how to connect your scripts to your MySQL databases.
Related Help Content
MySQL Connection Strings
This article will describe connections strings, what they are used for, and give examples.
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
Connecting to your MySQL DB from Dreamweaver
How can I connect to our MySQL database from Dreamweaver?
How To Reset MySQL Database User & Password
This article will explain how to change the password for a database in the event that the original password is lost.
How To Manage Databases With Command Line SSH
This article will instruct you how to export a database from the command line (SSH).
How Import Databases Using Command Line SSH
This article will instruct you how to import a database from the command line (SSH).
MySQL Database Compatibility
How do I make my MySQL database compatible with the version you provide?
Managing Your DB Using phpmyadmin
A repository of information on how you can manage your database by using the phpMyAdmin interface.