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)

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)

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.

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.

Plesk

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

• How to Whitelist Your IP - Windows Dedicated

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 the application.

Here is a helpful article about connecting to MySQL database via script.

• How to Connect to the MySQL Database