Error 1044 and 1045

[zdcshawn]

I am getting the 1044 error as soon as I enter "create database eq;" "use eq" "source db.sql", what am I doing wrong? I have tried a variety of things added on to the end of the command prompt, shut down, re-booted, rearched the forums for similar problems, and this is close but the 1044 error at a different part in creating the db

http://www.angelfire.com/ex/linkups/errors_w_eqemu.htm

For all you error needs <---- kinda corny

[DeletedUser]

• 1.

Start - Run - CMD

• 2.

CD c:\mysql\bin

• 3.

mysql -u root

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\*>cd c:\mysql\bin

C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 244 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

• 4. GRANT ALL PRIVILEGES ON eq.* TO mysqlname@localhost IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON eq.* TO *user*@localhost IDENTIFIED BY '*pass*' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

• 5.

C:\*>cd c:\mysql\bin

C:\mysql\bin>mysql.exe
ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: NO)

Edit:

Restart makes everything work

[krich]

Also, technically WITH GRANT OPTION is not necessary. In fact it's a bit of a vulnerability to have your eq ID set up with GRANT privileges. Not that we're running any production databases here, but you never know what people are willing to do on work computers...

Regards,

krich

[Gangrif]

worked for me.
not sure if you're doing it wrong. What i did was ran the mysql -u root mysql from the command prompt, not the mysql prompt. (Linux, not windows but should be the same?)

I must have done something right, it fixed my problem!

[Nicky]

Ok i understand all the stuf your telling us and im shu it will work great once i get one little thing fixed. My web master Deleted my root account so no matter what i do i cant get the thing to work right. I have tryed PhPmyAdmin and Naicat PhpMyAdmin allows me to Dreat the database but when i try to inport the .sql files i get a error saying colm numbers dont match i was told its a bug n the file im realy lost maby i could gt some help from some one who know what there doing once its working id be glad to give GM ststs to anyone who hlped me fix it

[adarhol]

thaks to everyone for the answers but what happen wneh i'm the root ando don't have any users What can i do?

thanks again

[Belfedia]

http://perl.about.com/od/installandu.../aa111400a.htm
http://dev.mysql.com/doc/mysql/en/installing.html
http://www.devshed.com/c/a/MySQL/MyS...Configuration/

Hope thats links can help