I have a MySQL database that I would like to remotely access from Windows Azure which does not provide fixed IP addresses at this point. Instead of white-listing a very large IP range to cover the entire Microsoft datacenter, it would be preferable to check for the hostname instead. Indeed, if I was allowing `myuser@'foo.example.com', DNS resolution being made when establishing a new connection to MySQL then varying IP address would not be an issue anymore.

Does anyone is such a scheme is possible with MySQL?

1 Answer 1


MySQL has supported DNS based authentication for a long time. The problem is that it needs you to set up the reverse as well as the forward lookups.

If you are able to set both the forward and reverse records then it all should be easy.

See the section about How MySQL Uses DNS in the manual for full details.

  • Your guess about reverse DNS was correct. At present time, reverse DNS is not properly setup on Windows Azure. Sep 8, 2010 at 19:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.