Re: anonymous user, localhost as host, % as host

[Barry Galbraith]

In the documentation PB pointed you to, take a look at this page.

http://dev.mysql.com/doc/refman/5.7/en/connection-access.html

It explains how the user table is sorted, then how the connection attempt is matched.
Basically, the table is sorted by most specific hostname first, and for each hostname, then most specific user first.

The first match is the one one used. If there is no match, connection is refused.

For any match in user/host, then a test of password (or not) is used.

Good luck,
Barry.