Re: Using NOIP provided hostname in MySQL user

[Glen McAllister]

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