Can I connect remotely to my remote MySQL DB?

+4 votes

 

Hi guys, I was wondering if anyone could provide me with a clear, concise answer on this question. I am currently hosted under a shared, linux hosting packages on which I have MySQL installations. I am developing a project in MySQL Workbench and would like to connect to my DB remotely so that I can develop and play around with the tables and queries straight from my workbench dashboard.
 
Thanks in advance guys :)
asked Oct 3, 2014 in Shared Hosting by anonymous
(Accidentally commented. See my answer below.)

3 Answers

0 votes

Afrihost does not allow outbound connection on MySQL. To achieve this you would need to go for a cloud server and enable those connection. MySQL connects to localhost only on shared hosting environment.

answered Oct 6, 2014 by AfriDude (43,930 points)
0 votes
The question is about an inbound connection (to connect to the hosting package database), which Afrihost does allow.
 
In the site's cPanel, go to Remote MySQL and enter your IP address. This needs to be your public IP address (do a Google search for "what is my IP address" to get it). If you're on ADSL this address may change regularly, so you probably want to add your IP address as xxx.xxx.xxx.% or even xxx.xxx.% on the Remote MySQL page. Then you can use the server's Shared IP Address (you can find it on the main cPanel page) as the server address in your connection string/options.
answered Jun 21, 2015 by Marc
0 votes
Sorry not supported
answered Aug 5, 2017 by RyanG (35,770 points)
...