Managing Your Database 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 chose depends on what type of database you are connected to.  All our web hosting plans offer MySQL, and MS SQL is available on our Windows hosting.

For MySQL, if you do not want to use a third-party application, you can use phpMyAdmin in cPanel or Plesk to manage your database, which can be accessed with a web browser.


Step 1: 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.  Many other applications are available and can be found by using a search engine.

MS SQL (Plesk / Windows Hosting)

Many other applications are available and can be found by using a search engine.


Step 2: Whitelisting Your IP

To connect remotely, you will need to whitelist your IP address.  You can get your IP address from: http://www.hostgator.com/ip.shtml

cPanel

  1. Login to cPanel and click the Remote MySQL icon, under Databases.
  2. Type in the connecting IP address, and click the Add Host button.
  3. All done, try connecting remotely.

Recommended Reading: How to connect to the MySQL database

Plesk - Windows Shared

Once you have it installed, your IP address will need to be whitelisted so that you can access MS SQL or MySQL remotely. Follow the directions in the article How to whitelist your IP for Windows Shared to accomplish that.

Plesk - Windows Dedicated

Once you have it installed, your IP address will need to be whitelisted so that you can access MS SQL or MySQL remotely. Follow the directions in the article How to Whitelist Your IP - Windows Dedicated to accomplish that.


Step 3: 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.