MySQL problem

[Yzien]

I need help with createing data base in MySQL.exe everytime i try it CODE: create database eq; it gives me an error saying access not granted on localhost@ any ideas on what the problem might be?

[cofruben]

open mysql.exe and try writing this:

GRANT ALL PRIVILEGES ON *.* TO yourusername@localhost IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

for example:


GRANT ALL PRIVILEGES ON *.* TO test@localhost IDENTIFIED BY '123456' WITH GRANT OPTION;

[Yzien]

it gave me

CODE:

(Using password: NO)

ERROR 1045:



????????IDK????????

[mikenune]

You're not logging in as root.

Start MySQL like this:

C:\mysql\bin> mysql -u root
Then you should be able to do what you want.

[Yzien]

that worked thanks a bunch