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) 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.

If you do not want to use a desktop application for MySQL, 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.

    Note: The Advanced tab will load your cPanel. Legacy accounts will feature a horizontal navigation bar at the top of the screen, while Bluerock account users will see a vertical navigation menu on the left-hand side of the screen. To learn more, please see Bluerock vs. Legacy.

    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.

    Important: 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

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.

For further assistance, you may contact our Chat Support or Phone Support via 888-401-4678. You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.