[TriLUG] MySQL Replication

[Brian McCullough]

On Thu, Jan 29, 2015 at 04:29:20PM -0500, Igor Partola wrote:
> > 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;`

Yes, they didn't worry me.  I knew what they meant.