If you need to connect to your database with third party software, a remote MySQL connection can be made to a database that you are hosting at Web Hosting Hub.
First, you will need to add the IP address that will be accessing the database. For security reasons, only confirmed IP addresses are able to connect to MySQL databases directly. If you will be connecting to the database from your current connection, you can find your IP address by visiting any of our servers' landing pages. Once you have obtained your IP address, log into your cPanel and click on "Remote MySQL" under the Databases subheader.
This is where you can add your IP address so you can connect to your database remotely. Copy and paste your IP Address in the box and click on "Add Host":
Now you will be able to connect to your MySQL Databases from the IP address you entered. You can add as many IP addresses as you need.
The general settings for connecting remotely to a MySQL Database are:
In the MySQL Databases section of your cPanel, any databases listed will look like this, with an example database name and username highlighted:
Once you have added the IP address in your cPanel and entered the correct information, you now will be able to connect to your database remotely. You can use programs such as Navicat and HeidiSQL to connect to your database remotely.
Email: | support@WebHostingHub.com | Ticket: | Submit a Support Ticket |
---|---|---|---|
Call: |
877-595-4HUB (4482) 757-416-6627 (Intl.) |
Chat: | Click To Chat Now |
We value your feedback!
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
new! - Enter your name and email address above and we will post your feedback in the comments on this page!