Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Tutorials/Howto's

Archive::Tutorials/Howto's Archive area for Tutorials/Howto's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #16  
Old 08-21-2003, 03:55 PM
zdcshawn
Fire Beetle
 
Join Date: Aug 2003
Posts: 2
Default 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
Reply With Quote
  #17  
Old 09-05-2003, 06:00 PM
Guest
 
Posts: n/a
Default

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

For all you error needs <---- kinda corny
Reply With Quote
  #18  
Old 10-22-2003, 04:24 AM
DeletedUser
Fire Beetle
 
Join Date: Sep 2002
Posts: 0
Default

  • 1.
Start - Run - CMD
  • 2.
CD c:\mysql\bin
  • 3.
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)
  • 5.
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
Reply With Quote
  #19  
Old 10-22-2003, 01:47 PM
krich
Hill Giant
 
Join Date: May 2003
Location: The Great Northwest
Posts: 150
Default

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
Reply With Quote
  #20  
Old 10-27-2003, 09:13 AM
Gangrif
Sarnak
 
Join Date: Oct 2003
Posts: 64
Default

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!
Reply With Quote
  #21  
Old 10-31-2003, 05:36 AM
Nicky
Fire Beetle
 
Join Date: Oct 2003
Location: USA - Washingtion
Posts: 1
Default 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
__________________
Build a man a fire and he will be worm for a day. Set a man on fire he will be worm for the rest of his life.
Reply With Quote
  #22  
Old 06-23-2005, 07:04 PM
adarhol
Fire Beetle
 
Join Date: Jun 2005
Posts: 1
Default 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
Reply With Quote
  #23  
Old 06-24-2005, 07:16 AM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

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
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:28 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3