In phpmyadmin I created a user called "edward" with password and all privileges:
Yet when I try to log in via phpmyadmin, it says "Cannot log in to the MySQL Server".
When I try to log in on the command line (Windows 7), it won't allow me either:
But if I login in without a password, I get in:
and shows me only two of the tables.
I'm sure the password is correct and I've created multiple users which all can't log in with their passwords no matter how many rights I give them.
How can I get this user to be able to log in only with password and see all databases?
Addendum:
Here is a screenshot from phpmyadmin showing that "edward" has just as many rights as "root":
Best Answer
Because you granted it access without password... If a user has no password, logging in with one will always fail.
Set the password for user, only then you'll be able to use
-p
In addition, you might want to remove the
Any
user.