24/7 U.S. Support – 877-595-4482
Many site owners have a developer working with them. In many cases, the owners will not wish to give full cPanel access to the developer. This can hinder the developer from working on specific things such as the database. While there are ways to allow access to the phpMyAdmin tool, the owner needs to do a bit of setup and sacrifice more space on the account. Another solutionto this problem is to allow the developer to connect with a remote database management tool, such as HeidiSQL. This article describes how to use HiediSQL to remotely connect to a database on your hosting account.
Before you can connect to your databases with any remote connection you will need to set your cPanel to accept connections from the IP address of the computer you want to work with. Below is a link with instructions on setting that up.
How to set up a remote MySQL connection.
Now that you have set the cPanel to accept the connecting machine's IP and installed HeidiSQL, it is time to set up the profile to make the connection.
|Network Type||MySQL (TCP/IP)|
|Hostname/IP||This is either the domain name you are connecting to, or the IP address of the server.|
|User||This is either the cPanel username or the specific username created for the database.|
|Password||This is the password for the username above.|
|Databases||Leave this blank and the available databases for your username will appear once logged in.|
|Startup Script||Leave this field blank.|
|Email:||support@WebHostingHub.com||Ticket:||Submit a Support Ticket|
|Chat:||Click To Chat Now|