[TriLUG] MySQL Replication

Igor Partola igor at igorpartola.com
Thu Jan 29 16:29:20 EST 2015


> Hmmm.  New messages in error.log, telling me that my "name" entries in my
"user" table will be ignored now that I have skip-name-resolve.

If you turn do skip-name-resolve, you cannot have anything but IP addresses
and '%' in the host column in either mysql.user or mysql.db. The easiest
way to see this stuff is to actually connect to the MySQL database and then
do `select user, host from user;` and `select user, host, db from db;`


More information about the TriLUG mailing list