2011-11-01, 12:38
what makoto is saying is that mysql seems to do DNS queries on the clients that connect to it.
Home networks usually do not have their own DNS server, so those lookups fail.
Instead you can put a line in /etc/hosts(on your NAS/Mysql running server) that tells your system the hostname of your clients.
But this is only a workaround, its probably better to just disable DNS lookups in mysql directly:
just add the "skip-name-resolve" directive in /etc/my.cnf
I'm not sure if this is actually your problem, but worth a try. In case it does not help, you should post a debug.log
Home networks usually do not have their own DNS server, so those lookups fail.
Instead you can put a line in /etc/hosts(on your NAS/Mysql running server) that tells your system the hostname of your clients.
But this is only a workaround, its probably better to just disable DNS lookups in mysql directly:
just add the "skip-name-resolve" directive in /etc/my.cnf
Code:
[mysqld]
...
...
skip-name-resolve
I'm not sure if this is actually your problem, but worth a try. In case it does not help, you should post a debug.log