SysAdmin

MySQL – can’t get hostname for your address

JJ
Jobin Joseph · Founder and CEO
·Published 29 February 2012·1 min read

I recently had an issue with mysql, One of our developer complained that he is not able to login to mysql via SqlYog, a MySql client.

The Error Message was,

Can’t get hostname for your address

Solution
**
**
Just add skip-name-resolve option to the [mysqld] section of your my.cnf/my.ini

`skip-name-resolve `

Jobin Joseph
Jobin Joseph, Founder and CEO
5x AWS Certified, ISO 27001:2022 Lead Implementer, 17+ years building cloud infrastructure for regulated industries.
About Jobin →

Reading this because your AWS bill or uptime is a problem?

30 minutes, direct with the founder, no sales pitch: one specific recommendation for your AWS workload.

Book a free 30-minute review
30 min Free Consultation →