Re: Using NOIP provided hostname in MySQL user

[Georgi Kodinov]

Glen,

What the server does at connect time is to get the peer IP and try to do a reverse DNS query (ip-to-DNS name). Then it uses the name the lookup provides and tries to match it against the list of user accounts (the host part).

I'd suggest you do netstat at the time your client connects, get the IP it uses and try to do a reverse DNS lookup on it from the server OS console.
You will then know what host name is returned by DNS.

The alternative is to turn off that reverse DNS lookup and stick to the raw IPs (via --skip-name-resolve).
See https://dev.mysql.com/doc/refman/8.0/en/host-cache.html for further instructions.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria