distal-attribute
distal-attribute
distal-attribute
distal-attribute

Unable to connect to remote database

User, date Message
Written by allawrence
2 years ago
Category: Creating a connection
4 posts since Sun, 06 Jan 13
Just installed HeidiSQL and attempting to connect to a remote mysql database.

Completed the form with all verified database info:
Host
DBnane
User
Password

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!!

Al
Written by jfalchMoney, Euro
2 years ago
383 posts since Sat, 17 Oct 09
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 ?
Written by allawrence
2 years ago
4 posts since Sun, 06 Jan 13
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

Written by jfalchMoney, Euro
2 years ago
383 posts since Sat, 17 Oct 09
sqlyog (commercial) has a feature (http tunneling) that enables access from outside in such situations.
Written by allawrence
2 years ago
4 posts since Sun, 06 Jan 13
Thanks... will check it out.
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by allawrence
2 years ago
4 posts since Sun, 06 Jan 13
Hi,

Any chance that once completed I can get notification? It would be appreciated!!
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
Yes, you can starr the issue after logging in with a Google account.
 

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