MySQL Forums
Forum List  »  Security

Using NOIP provided hostname in MySQL user
Posted by: Glen McAllister
Date: January 29, 2019 06:20PM


I’ve got a fully qualified hostname from (let’s say its
and I’ve added a MySQL user ‘user’@‘’ 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?



Options: ReplyQuote

Written By
Using NOIP provided hostname in MySQL user
January 29, 2019 06:20PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.