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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Latest Sites on SiteInfo

1. downingmedia.com
(2 hours ago)
2. outsourcedataworks.com
(1 day ago)
3. vodafone.co.za
(1 day ago)
4. remont-yug.com
(2 days ago)
5. njbanjiawang.com
(3 days ago)
6. giochi.com
(3 days ago)
7. briket-makinasi.blogspot.com
(3 days ago)
8. beijinghuisuo.com
(3 days ago)
9. joufp.com
(4 days ago)
10. justgoodlinks.com
(5 days ago)