Search code examples
mysqliphostname

MySQL error: Can't get hostname from your ip address

I use my remote MySQL database during long time.

But today I suddenly have found that I cannot connect to the database. I have got an error.

"Can't get hostname from your ip address".

I haven't changed anything in MySQL settings.

What's the problem?

Solution

  • Just add below in my.ini or my.cnf.

    [mysqld]

skip-name-resolve

    Linux:

    Otherwise, start MySQL server with the following flag:

    sudo service --skip-name-resolve

    For more information: http://dev.mysql.com/doc/refman/5.0/en/host-cache.html