EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   #2003 Error (Boot5zones.bat) (https://www.eqemulator.org/forums/showthread.php?t=11557)

mattmeck 01-25-2004 10:29 AM

Quote:

hmm move to dr3.. could you point to me where to get that? sorry, im lousy
Have you checked the big sticky titled NEWEST BINARIES (yes its all in caps) in the gereral support forum?

wize_one 01-25-2004 10:32 AM

what matt said..hehe

Mrfolx 01-25-2004 10:35 AM

oki doke, ;p thanks, hopefully ill be out of your hair for an hour :) thanks matt and wiz

erb2k 04-26-2004 06:11 AM

Mr's Errors and Mine
 
Ok I'm having the exact same error on bootup as MrFox only when I try to run mysql -u root mysql, it sends me to the dirrectory that mysql is in instead of running the mysql proggy :-(

Anyone know about this?

erb2k

valaerosilantix 04-26-2004 06:23 AM

ok, I had this trouble for a short time before I realized that SQL is case sensitive


check your db.ini file

make sure the name and password is exact (case sensitive)

Trouble should go away

That error simply means it cant find your database

mikenune 04-26-2004 08:12 AM

Quote:

Originally Posted by valaerosilantix
ok, I had this trouble for a short time before I realized that SQL is case sensitive

MySQL is only as case sensitive as the OS it's on. If you're running Windows then you don't need to worry about having the correct case. If you're running the MySQL server on Linux then you do.

Quote:

Originally Posted by Mrfolx
Query OK, 0 rows affected <0.03 sec>

If it said that 0 rows were affected (which it did) then it never added your user. I've run into that myself. For some reason it wouldn't create users for me through the command line. I would suggest using a program similar to PHPMyAdmin (only if you have a web server on that computer too) or MySQL-Front to create the user.

Or, if you wanna try it again then use the syntax below (just run the first line if your database is on the same computer as World.exe and Zone.exe).

Quote:

GRANT ALL on [database].* to '[username]'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;
GRANT ALL on [database].* to '[username]'@'%' IDENTIFIED BY '[password]' WITH GRANT OPTION;
Just be sure to replace the bold text with your database name, username, and password.

lordaltay2 04-29-2004 03:50 PM

Solution
 
Remove the "." infront of zone name the period.

Razukan 05-04-2004 05:12 AM

Im very Stupid
 
i typed in
mysql>GRANT ALL on eq to (user)@localhost IDENTIFIED BY (Password)WITH GRANT OPTION;

and he gave me that Error:

Error:1064 You have an error in Your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(Password) WITH GRANT OPTION' at line 1

anyone can help me???!!! :P :P :P

mikenune 05-04-2004 06:46 AM

Your password needs to be in quotes. Doesn't matter if it's double or single though.

Razukan 05-05-2004 12:42 AM

Thanks
 
IT WORKS!!!!! IM SO HAPPYYY!!!!!! :P :P :P


All times are GMT -4. The time now is 10:04 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.