MySQL Forums
Forum List  »  Security

Re: Using NOIP provided hostname in MySQL user
Posted by: Georgi Kodinov
Date: February 02, 2019 05:02AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using NOIP provided hostname in MySQL user
853
February 02, 2019 05:02AM


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.