Mysql Bug !!!

[Kran]

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

Anyone can help me plz !!! :( :( :(

[burthold]

your not logged in properly. If you can log into mysql as root

mysql -u root

Wes

[a_Guest03]

See the link in my signature: 1045 error fix.

[Kran]

who can i open mysql with this :

3. Open mysql using this command: mysql.exe --user=root eq

[a_Guest03]

Use a command prompt and type it in.

[geerux]

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

Anyone can help me plz !!! :( :( :(
It's not a bug, your single quotes are misplaced.

It's not 'kran'@localhost, it's 'kran@localhost' - mind the single quotes.

[Soldar]

hey i tried to put the single qoutse (') in the places you said and i still get error 1045 and another thing i onpen up command prompt type in 'mysql.exe --user=root eq' (without quotes) and it says
bad command file or name WHAT SHOULD I DO PLEASE HELP IN A HURRY

[tcsmyworld]

Open DOS window , change directory to mysql directory , then try typing in commands.

[strickjb]

that is the worst... ive spent roughly 4-5 hours fixing that stupid crap. I cant tell you how I finally fixed it but it had something to do with logging in as root, ill tell u that :)