Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2003, 07:42 AM
Melandril
Sarnak
 
Join Date: Jun 2003
Posts: 75
Default Missing Files and error 1064

I've tried three times to set up a server now...I'm sure I must be an idiot (for those of you with huge egos), but to get the heart of the matter, I noticed that on the previous two attempts that I seemed to fail at the source reloaddb.sql step. I opened up the file on my second failure but didn't notice anything exceptional. But before loading the command this time, I noticed that I was missing six entries
"grid.txt", "lootdrop.txt", "loottable.txt", "lootdrop_entries.txt", "loottable_entries.txt", and "npc_spells_entries.txt". So to get around this, I made dummy files with these names and got past that command prompt. Now the error I'm having is with the next line to enter
"GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';"
Which when I enter, either in caps or without, error 1064 which is a syntax error. What am I supposed to enter here?
Thank you all for any concern you show which provides positive effect =)
Reply With Quote
  #2  
Old 06-29-2003, 08:57 AM
Memener's Avatar
Memener
Dragon
 
Join Date: Jan 2003
Location: College park, GA (atlanta)
Posts: 640
Default

dont use the " " " " those will mess it up
__________________
AMD AM2 X2 3.01Ghz(OC'ed at 3.8Ghz) 4096MB DDR2 800 Geforce 8800 ultra SLI 1.2TB HD <-- All water cooled

Thanks to Imageshack.us for free image hosting!
Reply With Quote
  #3  
Old 06-29-2003, 09:17 AM
Melandril
Sarnak
 
Join Date: Jun 2003
Posts: 75
Default ...

I didn't expect it to a brilliant solution by creating those dummy files; but that still leaves me clueless as to what I should do. Where can I obtain the real files so that I can continue on with the errors.
Plus, what is the deal with that command before I'm supposed to close mysql.exe?
Reply With Quote
  #4  
Old 06-29-2003, 09:32 AM
IANumtin
Hill Giant
 
Join Date: Apr 2003
Location: EQEmu
Posts: 121
Default

Depending on what database you sourced in, some databases already have that command in there for you. After sourcing in the database, open EQ Admin and look on the "Zone Server Authorization" tab. If you see "%" and "GRANT" in there then there's no need to use it on mysql.exe. If you're running a LAN server, you can use the EQ Admin tool to add in account names and passwords for each machine you've set up to be on your LAN.
__________________
They say baldness is in the genes but I have hair in my jeans :>)
Reply With Quote
  #5  
Old 06-29-2003, 09:45 AM
Melandril
Sarnak
 
Join Date: Jun 2003
Posts: 75
Default EQ Admin

Which leads to another problem I'm having...I tried using the EQ Admin, but got errors listing an IP address and not recognizing the account and password set in the preferences...
My biggest problem is that the READMEs don't say anything that the website doesn't say...plus the files download aren't in the same place as the walkthroughs say.
Reply With Quote
  #6  
Old 06-29-2003, 09:56 AM
IANumtin
Hill Giant
 
Join Date: Apr 2003
Location: EQEmu
Posts: 121
Default

You have to point the installation to the correct folders. EQ Admin works off of MySQL so make sure your username and password in EQ Admin is set the same. If you have done this, then sorry..just trying to eliminate some possibilities for you.
__________________
They say baldness is in the genes but I have hair in my jeans :>)
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 08:50 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3