got a weird mysql 'issue'
 

I get an error # 1044 when trying to grant myself privileges to the eq db. i am trying to use

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

now Iv tried many many variations i'v seen on the board, I have swapped *.* with eq and eq.* and what I get back from the sql server is:

ERROR 1044: Access denied for user: '<my_username>@127.0.0.1' to database 'eq'

OR

ERROR 1045: Access denied for user: '<my_username>@127.0.0.1' (Using password: YES)

AND SOMETIMES

ERROR 1045: Access denied for user: '<my_username>@127.0.0.1' (Using password: NO)

what in gods name am I doing wrong?? ANY help would be greatly appriciated! thank you kindly in advance.

-Jaysin

did you open
c:\mysql\bin mysql -u root mysql

that puts you in as root user with ability to grant?

KG

that is correct - you should append

--u root

to the mysql.exe command.

c:\mysql\bin\mysql.exe -u root <password>

and then you should be able to use the grant command