Using NOIP provided hostname in MySQL user
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
Subject
Views
Written By
Posted
Using NOIP provided hostname in MySQL user
4351
January 29, 2019 06:20PM
1354
February 02, 2019 05:02AM
1018
February 04, 2019 02:22AM
789
April 17, 2019 07:13AM
1363
April 17, 2019 06:08PM
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.