MySQL: Can’t get hostname for your address

Can”t remotely login to your shiney, new MySQL server due “Can’t get hostname for your address” or “Can’t get hostname for your address”. Another random MySQL error message.

Simply put, if you look in the logs, MySQL cannot lookup your IP/hostname. Its that simple.

Is your DNS broke? Or just on a Local Area Network with no DNS anyway?
Just add skip-name-resolve option to the [mysqld] section of your my.cnf/my.ini

18 thoughts on “MySQL: Can’t get hostname for your address

  1. Excellent answer

  2. thank you very much brother
    it is the best solution

  3. Thanks man! you help me a lot!

  4. Quick & Best solution! Thanx!

  5. thanks! why important information is out of mysql documentation? sinceraly, many thanks.

  6. Thanks man! Finally a solution.

    Cheers Joe

  7. Excellent!

  8. Thanks for this life saving piece of information!!

  9. Not working for 5.5.10 version. The server wont start if I add skip-name-resolve option.

  10. its very helpfull. thx very much

  11. a lot of thanks from germany

  12. thank you so much man. Hugs from Mexico.

  13. Can i have sex with you?

  14. Pics first.

  15. Thanks for man!!!!!!!!

  16. really nice! thanx!

  17. yup sure helped me out… now I just gotta get this silly site up and running properly.