When try to connect remote MySQL Sever 5.5 then it generate an error message 'Can't get host name for your address'. I don't know the exact reason for this error, but in my assumption MySQL Server can't resolve the host IP/name which we pass to server for establishing connection.To solve this issue, just add 'skip-name-resolve ' in my.ini /my.cnf under [mysqld] and restart the server. In windows this file location is
C:\Program Files\MySQL\MySQL Server 5.5\my.ini
[mysqld]
skip-name-resolve
Hi Alpesh,
ReplyDeleteI am glad & happy to see this site, this site is very useful and also very nice site.
thanks & best regards.,
Madan
Clarion technologies.,Bangalore