MySQL Forums
Forum List  »  Newbie

anonymous user, localhost as host, % as host
Posted by: Alexander Lazarev
Date: November 16, 2015 09:30AM

How to explain such thing:
There are few users for example:
''@'db.host.com'
''@'localhost'
'normaluser'@'%'

If im trying to connect as normaluser from localhost then I receive 'access denied'. Then I delete anonymous user (''). Connecting again as normaluser from localhost - access granted.
I suppose there is some magic happening with sorting of mysql.user table, but Im not sure.
MySQL version 5.5.25.

Options: ReplyQuote


Subject
Written By
Posted
anonymous user, localhost as host, % as host
November 16, 2015 09:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.