Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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@'', 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?

share|improve this question
up vote 3 down vote accepted

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.

share|improve this answer
Your guess about reverse DNS was correct. At present time, reverse DNS is not properly setup on Windows Azure. – Joannes Vermorel Sep 8 '10 at 19:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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