grant all privileges?
 

alright, this deals with mysql.exe -
i have finished everything and when i try to type
GRANT ALL PRIVILEGES on *.* to '%'@localhost IDENTIFIED BY '%';

i get an error message reading

ERROR 1045: Access denied for user '@127.0.01' (Using password: no)

does anyone know what this means? i read through the GRANTING AND REVOKING part of the manual at www.mysql.org but i still cant figure it out, can someone help please?


edit -- i just found and followed the 1045 fix instructions at http://www.kotcb.9f.com/1045fixes.htm and it didnt work for me :(

dont use the mysql 4.+ you need the mysql 3.23

I use the new MYSQL. What I found is that you have to specifiy the account that you actually use to connect to the MYSQL databases in the Grant Option Command.
I used the '%' and it didn't work but when I entered 'mysql' which is the account I use it worked fine.

I hope this helps anyone trying the Grant command with new MYSQL