I was able to fix these by manually making the directory and then giving it to the mysql user.

At that point you will get a different error message if you dont provide the correct password.

If not done somehow on successive re-installations it does not show that password.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

We can login with MySQL root with this command: mysql -u root -p.

By - sql tutorial - team Copy Code Then when we create a new user bill with host CREATE USER bill IDENTIFIED BY passpass.

By - sql tutorial - team Copy Code Granted all the privileges to user bill: grant all privileges on.

By - sql tutorial - team Copy Code we enter the correct password and get this error: ERROR 1045 (28000): Access denied for user billlocalhost (using password: YES).

When multiple matches are possible, the server must determine which of them to use.

Hence, such an anonymous user would mask any other user like anyusername when connecting from localhost.

The recommended solution is to drop this anonymous user (this is usually a good thing to do anyways).

By - sql tutorial - team Copy Code and got this error ERROR 1045 (28000): Access denied for user billlocalhost (using password: YES).

By - sql tutorial - team Copy Code mysqld is expecting you to connect as email protected Try creating email protected CREATE USER email protected IDENTIFIED BY passpass.

By - sql tutorial - team Copy Code If you want to connect remotely, you must specify either the DNS name, the public IP, or 127.0.0.1 using TCPIP.

By - sql tutorial - team Copy Code Once you login, please run this SELECT USER(),CURRENTUSER().

By - sql tutorial - team Copy Code USER() reports how you attempted to authenticate in MySQL CURRENTUSER() reports how you were allowed to authenticate in MySQL from the mysql.user table This will give you a better view of how and why you were allowed to login to mysql.

Why is this view important to know It has to do with the user authentication ordering protocol.

By - sql tutorial - team Copy Code OK watch me login as anonymous user: C:MySQL5.5.12mysql -urol -Dtest -h127.0.0.1 --protocolTCP.

Mysql Access Denied For User 'Root'@'Localhost' (Using Password: Yes) Mac