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.
Step 1: Download the Application
MySQL (cPanel or Plesk)
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.
MS SQL (Plesk / Windows Hosting)
You may choose to use one of the following applications.
- SQL Server Management Studio from Microsoft (free)
- EMS SQL Manager for SQL Server (free or commercial)
- EMS SQL Management Studio for SQL Server (commercial)
- urSQL (shareware)
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.
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:
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.