EQEmulator Forums - Error 1044 and 1045

Page 2 of 2

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Tutorials/Howto's (https://www.eqemulator.org/forums/forumdisplay.php?f=619)

- - Error 1044 and 1045 (https://www.eqemulator.org/forums/showthread.php?t=6119)

zdcshawn

08-21-2003 03:55 PM

1044

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

09-05-2003 06:00 PM

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

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

DeletedUser

10-22-2003 04:24 AM

Start - Run - CMD

CD c:\mysql\bin

mysql -u root

Quote:

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;

Quote:

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

Quote:

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

10-22-2003 01:47 PM

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... :shock:

Regards,

krich

Gangrif

10-27-2003 09:13 AM

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! :D

Nicky

10-31-2003 05:36 AM

Plz Help

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

06-23-2005 07:04 PM

Error 1045

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

06-24-2005 07:16 AM

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 :)

All times are GMT -4. The time now is 10:17 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page