'myname'@'%' can access to mysql server remotely but not with 'myname'@'123.456.489.%'

Question

I am working on accessing to mysql server remotely. My home pc to pc at the office.

I can access with 'myname'@'%'.

but I can't with 'myname'@'123.456.489.%'. '123.456.489.012'(redacted) is the IP address(IPv4) of my home pc.

I got this error:

I don't know why.

(456 and 489 are not valid IPv4 octets; I hope that was just redacting.) — Rick James, Aug 23 '20 at 14:26

score 0 · Answer 1 · answered Aug 30 '20 at 17:05

Your MySQL server is resolving IP addresses to names before checking whether the connection is allowed. Thus it is checking the hostname of your IP address instead of the address itself, which is what you had configured.

You can turn off this behavior with skip-name-resolve.

For example:

 [mysqld]
 skip-name-resolve

'myname'@'%' can access to mysql server remotely but not with 'myname'@'123.456.489.%'

1 Answers1