Pages

Thursday, March 31, 2011

MySQL Error : Can't get hostname for your address

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

No comments:

Post a Comment