Error 2005

[kursh]

i am unable to connect to a remote mysql database if i am using adress name instead of ip adress.

When i use global IP adress something like this: “85.206.xxx.70” in a mysql host address line it connects and works fine, but when i change IP to a name adress “myadress.no-ip.biz” i get this error no. 2005 unknown mysql server host blah blah.. I check my account at no-ip.com it shows that “myadress.no-ip.biz” is correctly pointing to my ip adress “85.206.xxx.70”, i also check it with run>cmd>nslookup 'myadress.no-ip.biz' i get answer with '85.206.xxx.70', so i am assuming its a problem with sqlyog how it interpret mysql host address diven as “myadress.no-ip.biz”. I need to use no-ip because i have dinamic ip's on a remote mysql server

[peterlaursen]

 It is not a problem with SQLyog. Could you try another client please (like Query Browser for instance).  The error 2005 is not coming from our code but from the MySQL API.  Any client compiled with same API will do the same. MySQL documentation about errors:

http://dev.mysql.com/doc/refman/5.1/en/error-handling.html

note that MySQL server errors have the format 1xxx and client errors 2xxx

Please check if this will help:

http://webyog.com/fa…erver-host.html

http://webyog.com/fa…-at-an-isp.html

Besides I can connect to MySQL running at webyog.com. But here the MySQL hostname and the OS/Linux hostname is the same 

[kursh]

now it is connecting all right, the problem was probably with DNS cache, thanks for reply

[Author]

Posts