Using NOIP provided hostname in MySQL user

[Glen McAllister]

Hi,

I’ve got a fully qualified hostname from noip.com (let’s say its myhost.ddns.net)
and I’ve added a MySQL user ‘user’@‘myhost.ddns.net’ in an attempt to let me connect to MySQL from the WAN via port forwarding with this user from my host.

When I try to do so, MySQL Workbench throws the error, "Host ‘<my IP address>' is not allowed to connect to this MySQL server.

Now - I know this has something to do with what’s returned by my DNS for this host. A DNS lookup for his host returns the (correct) IP, but this IP may change, which is why I got a NoIP hostname in the first place. How do I make MySQL happy to accept a connection from this host without using the IP which is subject to change?

Thanks,

GAM