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. Third parties supply these applications - some are free, and some may require you to purchase a license.
The database management program (application) you choose depends on the 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:
- 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: Whitelist your IP
You will need to whitelist your IP address to connect remotely. To find your computer's IP Address, use Google to search for 'what is my IP' or go to https://www.google.com/search?q=what+is+my+ip. Google will display your IP address in the search results. Please note this feature is only available in English.
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.
To access MS SQL or MySQL remotely, you may want to check out these articles:
Step 3: Connect to MySQL Database
How you connect to your database will depend on what program you choose to use. The third-party website where you downloaded the application should provide instructions on how to use their application.
Here is a helpful article about connecting to MySQL database via script.