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":
SET PASSWORD FOR 'edward'@'%' = PASSWORD( 'YOU PASSWORD HERE' )
.