MySQL Forums :: MySQL on Amazon EC2 :: mysql access control with public DNS names

I have a simple two tier setup on EC2 with one webserver and one DB server.

I do plan on scaling in the future though, so I have made some DNS A records and CNAME anticipating some horizontal scaling.

One thing I'm having trouble with though is mysql access control.

For example, I'd like to create a user in MySQL that can only connect from localhost and from my web server. My webserver has an A record in my DNS (dynDNS) pweb1.mydomain.com , and a CNAME to it of pweb.mydomain.com.

I'd like to setup the access record in MySQL to allow the db user (from my web application) to connect from 'pweb.mydomain.com', but I always get an error like:

Access denied for user 'myuser'@'174.129.34.65'.

So obviously it's an issue with MYSQL being very strict about the access control. Is there a way I can tell it to accept a CNAME alias, or do some sort of loose IP checking?