Granting access

[Karnan]

When i type

Type in: GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

I get

ERROR 1045: Access denied for user: '@localhost' <Using password: NO>

Anyone have any ideas? :(

[Lurker_005]

should be '%@localhost' not '%'@localhost

[Karnan]

changed it and still got same error.

[Karnan]

GRANT ALL PRIVILEGES ON *.* to '%@localhost' IDENTIFIED BY '%';

Thats what it should be right?

[Squiffy]

Did you log in as root? And is % your username and pwd?

[Karnan]

How do i log in as root and is this how it should be..

GRANT ALL PRIVILEGES ON *.* to 'username@localhost' IDENTIFIED BY 'password';

?

[Squiffy]

mysql -u root mysql

and I THINK you need to drop the quotes around the username bit... and don't forget grant option

GRANT ALL PRIVILEGES ON *.* to username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;