Adding new users

[trib4lmaniac]

I can't seem to add a new user to my database! I've tried it through phpMyAdmin (under privileges) and also running the query
GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION

which returned no errors and according to phpMyAdmin the user is entered into the `users` table. But when I try to login with that name I get
Access denied for user: 'myusername@localhost' (Using password: YES)

So all I can use to login is 'root' with no password. Not very secure!

No idea what else to try :confused:

[raf]

did you flush the privilkedges ?

check out
http://dev.mysql.com/doc/mysql/en/Access_denied.html

[trib4lmaniac]

Yes :(

[trib4lmaniac]

Ok, if i add a new user but do not give him a password i can logon fine! A user with a password cannot logon :confused:

[trib4lmaniac]

No-one has any ideas on this!?

[raf]

There's not much we can see about it.

Makes sure you go through the dow for creating a new user and folow all steps there.

[trib4lmaniac]

* BUMP *

This still stands