1045 Mysql ...$#@$%#% =P

[n0sn0s]

Ok I read like 3 different posts where folks explain how to get past this problem. I tried all of them and wound up with the exact same output every single time. =P I've reread the manual like 20 times and can't seem to find what I've done wrong with MYSQL. But here it goes ...

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

Also tried someones suggestion of doing it this way with the exact same effect ...

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


Thanks for any help ...sorry I know it's been asked a dozen times over again but none of what people have posted in explanation of the problem seems to be helping me. =P EQEMu 0.4.4, and the latest version of win32 MYSQL is what I am using if that helps.

Thanks in advance,

n0s

[predominant]

Sounds like you;re not authorised to make grants.

Are you just typing:

mysql

at the command prompt?

if so, try starrting mysql with the following:

mysql -u root

... then try the previously attempted commands

Let me know what happens, ,we'll see if we can get you through this

[useless]

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

the end should look like this

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

http://www.kotcb.9f.com/1045fixes.htm


got there for one of the 50 fixxes burried in these forums

[Saethan]

if so, try starrting mysql with the following:
Quote:

mysql -u root



... then try the previously attempted commands

Let me know what happens, ,we'll see if we can get you through this

I was going insane trying to figure out what I was doing wrong. mySQL newbie. This worked for me.