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

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

Sounds like you;re not authorised to make grants.

Are you just typing:
at the command prompt?

if so, try starrting mysql with the following:
... then try the previously attempted commands

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

the end should look like this

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


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

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