Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 4 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

 
discard

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.