mysql authorization ??

[Anon]

Hi, I created a mysql database called wapdemo
and when trying to connect to it, I got this error :
Error: 500
Invalid authorization specification: Access denied for user: 'wapdemo@localhost' (Using password: YES)

Could you please help.
Thanks

[Anon]

Check the MySQL manual for the GRANT statement

[Anon]

I checked , and I gave grant to wapdemo user like this :
mysql> INSERT INTO user VALUES('localhost','wapdemo',PASSWORD('password'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

but still giving me the same error.

[[deleted]]

Try using the GRANT statement instead.

[Anon]

I have done it two minutes ago, but stll the same.
thanks

[[deleted]]

did you reload the grant tables?

[Anon]

I am sorry, what do you mean by reload ?
Thanks

[neuromancer]

Try using mysql -uwapdemo -hlocalhost -p

If you leave the password (-p) parameter off it always tries a empty password