Unable to connect to remote database

allawrence posted 5 years ago in Creating a connection
Just installed HeidiSQL and attempting to connect to a remote mysql database.

Completed the form with all verified database info:

I am using 1and1.com as my host. Have accessed the database successfully using another frontend mysql application, as well as from my web site (using the info in database to create web pages.

I have tried this numerous times with this error:

SQL Error (2003): Can't connect to MySQL server on 'database URL' (10060)

This is driving me crazy and would appreciate any suggestions!!

jfalch posted 5 years ago
many large intenet hosters do not allow access to their db servers from the outside; this may well be the case with 1and1.

db´s at such hosters are only accessible to php etc applications also running on the hosters servers; ie your php app can see the database, web based db access (eg phpMyAdmin and such) running on the hosters server can see the database, but you will not be able to access it from "outside" (eg using heidisql). ask 1and1 support about this.

PS: what "antother frontend" did you use ? was it web-based ?
allawrence posted 5 years ago
Ahhh, you are correct. 1and1 does not allow access from outside their environment!!!

I did not realize that HeidiSQL did not install on my web site, although I should have realized that as I was filling out the mySQL info unhappy

The "other frontend" was/is DaDaBIK.... that and all others were installed on the web site and accessed thru there. Just looking for alternatives....

Thank you for the response

jfalch posted 5 years ago
sqlyog (commercial) has a feature (http tunneling) that enables access from outside in such situations.
allawrence posted 5 years ago
Thanks... will check it out.
ansgar posted 5 years ago
There is a feature request, see issue #1405, which asks for HTTP tunneling in HeidiSQL as well. However, that will definitly take some time to finish, although there was the first development progress recently.
allawrence posted 5 years ago

Any chance that once completed I can get notification? It would be appreciated!!
ansgar posted 5 years ago
Yes, you can starr the issue after logging in with a Google account.

Please login to leave a reply, or register at first.