Mysql Bug !!!

Kran · #1 07-05-2003, 09:01 AM

Quote:

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 · #2 07-05-2003, 09:02 AM

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

mysql -u root

Wes

a_Guest03 · #3 07-05-2003, 12:24 PM

See the link in my signature: 1045 error fix.

Kran · #4 07-05-2003, 09:51 PM

who can i open mysql with this :

Quote:

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

a_Guest03 · #5 07-06-2003, 03:27 AM

Use a command prompt and type it in.

geerux · #6 07-08-2003, 06:16 AM

Quote:

Originally Posted by Kran

Quote:

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 · #7 07-09-2003, 04:45 AM

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 · #8 07-10-2003, 03:15 PM

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

strickjb · #9 07-11-2003, 06:31 PM

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