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

1 comment:

  1. Hi Alpesh,

    I am glad & happy to see this site, this site is very useful and also very nice site.

    thanks & best regards.,
    Madan
    Clarion technologies.,Bangalore

    ReplyDelete