mysql -ubill -ppass \ĮRROR 1045 (28000): Access denied for user (using password: YES) Mysql> CREATE USER IDENTIFIED BY 'anotherpass' ĮRROR 1045 (28000): Access denied for user (using password. Mysql> SHOW VARIABLES LIKE 'skip_networking' Įxact same setup, except I re-activated networking, and I now create an anonymous user. mysql -ubill -ppass -socket=/tmp/mysql-5.5.sock These are only meant to answer some questions raised in other comments within this thread.Īuthenticating as through a. The recommended solution is to drop this anonymous user (this is usually a good thing to do anyways).īelow edits are mostly irrelevant to the main question. Hence, such an anonymous user would 'mask' any other user like when connecting from does match but would match (e.g.) beforehands. Literal host names and IP addresses are the most specific.
The server uses sorting rules that order rows with the most-specific Host values first. When multiple matches are possible, the server must determine which of You probably have an anonymous user or per the manual:
