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

mysql ip hostname
Jean Louis picture Jean Louis · Feb 25, 2011 · Viewed 50.5k times · Source

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?

Answer

Ravi Parekh picture Ravi Parekh · Mar 24, 2011

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

Related questions

What does MySQL "::1" hostname refer to?

On a freshly installed (windows version of) MySQL 5.5.9 SELECT user, host FROM mysql.user gives: user host root localhost root 127.0.0.1 root ::1 localhost But what IP/hostname does ::1 stand here for?

Read More
IP address storing in MySQL database using PHP

what is the right field type for IP address in mysql? and what is the right way of storing it using PHP?

Read More
Is there way to match IP with IP+CIDR straight from SELECT query?

Something like SELECT COUNT(*) AS c FROM BANS WHERE typeid=6 AND (SELECT ipaddr,cidr FROM BANS) MATCH AGAINST 'this_ip'; So you don't first fetch all records from DB and then match them one-by one. If c > 0 then were …

Read More