1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Managing Your Database With Applications

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 may require you to purchase a license.

The database management program (application) you chose depends on 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.

MS SQL (Plesk / Windows Hosting)

You may choose to use one of the following applications.

You may look for other applications for MS SQL by using a search engine.


Step 2: Whitelisting Your IP

You will need to whitelist your IP address to connect remotely. To get your IP address, you may want to visit: https://www.hostgator.com/ip.

cPanel

For instructions on how to whitelist your IP address via your cPanel, please visit the article, Whitelist Your IP in cPanel for Remote MySQL Access.

Here is another helpful article:

Plesk

To access MS SQL or MySQL remotely, you may want to check out these articles:


Step 3: Connect to the MySQL Database

How you connect to your database will depend on what program you chose to use. The third-party website where you downloaded the application should provide instructions on how to use their application.