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
Unable to connect to remote database
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 ?
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 ?
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
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
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
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
sqlyog (commercial) has a feature (http tunneling) that enables access from outside in such situations.
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.
Please login to leave a reply, or register at first.