I had a similar problem. I fixed it by removing the two auto-created anonymous localhost
users. These had higher precedence in the MySQL user-matching ordering, because
'localhost' is more specific than '%'.
Order matching: http://dev.mysql.com/doc/refman/5.0/en/connection-access.html
(It is a common misconception to think that, for a given username, all rows that
explicitly name that user are used first when the server attempts to find a match for the
connection. This is simply not true....)
As explained in the upstream bug report:
I had a similar problem. I fixed it by removing the two auto-created anonymous localhost
users. These had higher precedence in the MySQL user-matching ordering, because
'localhost' is more specific than '%'.
References: dev.mysql. com/doc/ refman/ 5.0/en/ default- privileges. html
Anonymous users are created by default:
http://
Order matching: dev.mysql. com/doc/ refman/ 5.0/en/ connection- access. html
http://
(It is a common misconception to think that, for a given username, all rows that
explicitly name that user are used first when the server attempts to find a match for the
connection. This is simply not true....)