MySQL Error: Can’t get hostname for your address

This error is thrown by MySQL because it tries to do a DNS lookup on the address connecting to the server and it fails due to the IP not being able to be resolved back to a name or some-other deeper DNS bust problem.

The easiest way to fix this is to edit your my.ini or my.cnf (/etc/my.cnf) and in the
[mysqld] section add the “skip-name-resolve” option.

Near the top of the file this will look similar to the below:

[mysqld] skip-name-resolve
Code language: CSS (css)
Notify of
Inline Feedbacks
View all comments