MySQL Forums
Forum List  »  Security

Re: Using NOIP provided hostname in MySQL user
Posted by: Glen McAllister
Date: February 04, 2019 02:22AM

Hi Georgi,

I kind of knew all that, and have tried to cope with what comes back from a reverse nslookup, but with no success by adding the following entries into /etc/hosts on the MySQL server:

<host IP> <noip hostname>
<host IP> <ISP hostname>

Then I adjust the MySQL account to use the noip or ISP hostname; ie. ‘user’@‘<noip hostname>' or ‘user’@‘<ISP hostname>'

Whatever I do, with only 1 exception, I get:

"Host ‘<host IP>' is not allowed to connect to this MySQL server. One time, I did get:

‘<ISP hostname>’ is not allowed to connect to this MySQL server, but I have not been able to duplicate this.

I am using flush hosts and flush privileges after connection attempts and account alterations respectively.

Thanks,

GAM

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using NOIP provided hostname in MySQL user
636
February 04, 2019 02:22AM


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.