Access Denied mysql after creating user, granting, and flushing

Question

I am making this https://stackoverflow.com/a/18756674/1197775.

But I am getting this:

mysql -uspot -pfakepasswd
ERROR 1045 (28000): Access denied for user 'spot'@'localhost' (using password: YES)

How can I debug this problem?

Update

I also tried MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES).

No anonymous users anymore, but no luck yet.

Update 2

SELECT User,Host FROM mysql.user;

+------------------+-------------------+
| User             | Host              |
+------------------+-------------------+
| root             | 127.0.0.1         |
| root             | ::1               |
| spot             | %                 |
| root             | localhost         |
+------------------+-------------------+

That means don't paste your password hashes in when you answer my question. :) — David Hoelzer, Oct 07 '13 at 14:47
I see your answer up there. What's showing up in the log when you get that error? — David Hoelzer, Oct 07 '13 at 14:48
should I use host option or connect through socket? I understand from that table connection from any host is allowed for `spot` ... — sites, Oct 07 '13 at 16:56
How did you drop the anonymous user? You may need to flush privileges (or just restart your server). Also yes try to specify the `-h` option, just in case. Are you connecting from localhost? — RandomSeed, Oct 08 '13 at 06:20

score 0 · Answer 1 · answered Oct 06 '13 at 20:57

0

Try 'mysql -u spot -p' and then enter the password.

answered Oct 06 '13 at 20:57

Manuel Darveau

4,175
3
23
35

Access Denied mysql after creating user, granting, and flushing

Update

Update 2

1 Answers1