Error 1045

[Error69]

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

I get this error when i type GRANT ALL... any help is nice

[Error69]

i really need an answer please im trying to start a server

[Monrezz]

Replace '%' with your username / password found in db.ini

If it still gives error remove my.ini file in C:\Windows\ then run mysqladmin and reenter username/password.

If it still gives uninstall mysql, delete mysql directory and my.ini, and then reinstall.

Originally Posted by Error69

Posted: 02-20-2004 02:27 AM

Originally Posted by Error69

Posted: 02-20-2004 03:33 AM

Wait more than an hour before bumping, give people a chance to answer :P

[Error69]

so it should look like GRANT ALL PRIVILEGES ON *.* to Kain/pass@localhost IDENTIFIED BY Kain/pass;

or

GRANT ALL PRIVILEGES ON *.* to 'Kain/pass'@localhost IDENTIFIED BY 'Kain/pass';

or GRANT ALL PRIVILEGES ON *.* to 'Kainpass'@localhost IDENTIFIED BY 'Kainpass'; and the oher way without the '

[Error69]

ok if any1 posts post for future reference some1 has helped me fix it