1. bluehost knowledge base

Managing Databases with Applications

Overview

Many applications 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, and MSSQL is available on our Windows hosting environment.

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: MySQL (cPanel or Plesk)

Download one of these applications:

The applications above are designed for managing databases. Some web development software, like Dreamweaver, can also connect to MySQL remotely. To learn more, please refer to Remote Database Connection Setup. Also, 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.

  1. Log in to your Bluehost control panel
  2. Locate the Remote MySQL icon.

    Bluerock Account

    • Click the Advanced tab from the side navigation menu to the left.
    • Click the Remote MySQL icon, located in the Databases section.
      rock-advanced-database-remote-mysql

    Legacy Account

    • Select the cpanel sub-menu from the navigation menu that stretches across the top of your screen.
      legacy-cpanel-tab
    • Scroll down and select the Remote MySQL icon under the database tools section.
      legacy-database-remote-myaql
  3. Under the Add Access Host, located at the top of the page, enter the IP Address inside the "Host (% wildcard is allowed)" infobox.

    Take Note:

    • You may enter a fully qualified domain name (FQDN) or an IP address.
    • You may use the percentage sign character ( % ) as a wildcard.
       For example: to allow access from all IP addresses that begin with 162.76.24, enter 162.76.24%.
    • We recommend following MySQL rules to use a range of IP addresses. For more information, you visit this article MySQL Documentation.
  4. You may also enter any preferred comment inside the "Comment (optional)" infobox.

    Take Note: We recommend limiting the description to 255 characters (ASCII), and this step is optional only.

  5. Once done, click the Add Host button.
    rock-advanced-database-remote-mysql-add-access-host

Recommended Reading: Connecting Scripts 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.