anonymous user, localhost as host, % as host
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.
Subject
Written By
Posted
anonymous user, localhost as host, % as host
November 16, 2015 09:30AM
November 16, 2015 12:00PM
November 17, 2015 04:53AM
November 17, 2015 04:56PM
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.