Well I thought everything was right.. Get this
 

Hola folks,

I did RTFM x3 and know my dos command read the server setup html file, did all the right things from what i can tell. But my server still shows locked on the server page, and I cannot seem to flag the account. I'm lost?!?! help please.. Here is my info and file paste.

WinXp Pro (whistler) 2100 amd 1gig ram Biz class cable (pay the extra $25.00 it is WELL worth it) geforce 3 64mb (missing anything?)

db.ini

[Database]
host=localhost
user=********
password=*******
database=eq

loginserver

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=The Whyte House
locked=false
account=
password=
worldaddress=***.***.***.***
[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

when running world I get

D:\EQSERVER>world
Failed to connect to database: Error: Access denied for user: '******* @localho
st' (Using password: YES)
EQEMu 0.4.1 Spekkio
Error in GetVariable query 'SELECT value FROM variables WHERE varname like 'hold
zones'' #2006: MySQL server has gone away
Loading zone names & items...
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #2006: MySQL
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
...done.
LoginServer.ini read.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank
4title, rank5, rank5title from guilds' #2006: MySQL server has gone away
done.
Loading EQ time of day...Reading time file failed, bytes read: 0
failed.
HELP I WORK IN THE EQEMU SWEATSHOP YOUR MY ONLY HOPE
World server listening on: port 9000
Connected to LoginServer: eqlogin1.eqemu.net:5999

When I try to flag the account I get

D:\>cd eqserver

D:\EQSERVER>world,exe flag eqemu 200
Failed to connect to database: Error: Access denied for user: 'bkw @localho
st' (Using password: YES)
EQEMu 0.4.1 Spekkio
Error in GetVariable query 'SELECT value FROM variables WHERE varname like 'disa
blecommandline'' #2006: MySQL server has gone away
Error, unknown command line option


mysqladmin is running, and I went through the steps outlined in the following post..

Posted: 07-16-2002 12:44 PM Post subject: Newbie Walkthrough for creating a Standalone LOCAL server us

im lost.. Im a hardware guy who enjoys EQ. Any help would be Great..

Thanks

Buck

Well, this is a big hint...


Failed to connect to database: Error: Access denied for user: '******* @localho
st' (Using password: YES)


There are about 100 threads on this same problem...

hmmm.. 78+ Pages of posts, and nothing
 

Well, I followed your HINT, and searched for my error again (did this once before) and only few ask a similar question, and they were never answered or were answered with check the board :? According to the Doc..

If you receive a message saying Access Denied blahblah@localhost blah blah error. Try running Winmysqladmin.exe in the background.
If that does not work reboot your machine

"And if that does not help. Open mysql.exe ( found in c:\mysql\bin )
Type in: GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%'; (press enter)
Close out of mysql.exe

IMPORTANT NOTE: CONTINUE ONLY IF THERE ARE NO ERROR MESSAGES
IMPORTANT NOTE: CONTINUE ONLY IF THERE ARE NO ERROR MESSAGES
IMPORTANT NOTE: CONTINUE ONLY IF THERE ARE NO ERROR MESSAGES"

But it does not go any further than that. Can you give me a bigger hint maybe? BTW I did the previous, and still no help. Maybe im blind and just didnt see it.. But my eyes hurt from reading all those posts.. LOL

Thanks

Ignore the winmysqladmin junk....


run mysql (from a dos window, cd c:\mysql\bin ; mysql )

mysql>

GRANT ALL PRIVILEGES ON *.* to userid@localhost IDENTIFIED BY 'password';

userid is whatever you set for your database id, password is the same..


Thats what ya need to do... Dont use % @ % identified by %

All I would need is your ip address then, and I could wipe out your databases...

What a mess..
 

I used the following line as you suggested..

GRANT ALL PRIVILEGES ON *.* to bkw@localhost IDENTIFIED BY 'password';
It accepted that fine, closed out mysql. Rebooted, tried to load world. Same thing.. I have winmysqladmin loaded. Is my path to the DB missing? I dunno.. Seem to be an access error of some kind, but im really not sure where to go from here.. I read post about white spaces.. checked had none before username or password.. should I scrap the whole thing and start over again?

(prepares to loadf pistol)

Thanks

try a

mysql -h localhost -u user -p

then enter in your password. If it works, theres no reason you shouldnt be able to get in. If it doesnt work, you're permissions havent been set right.

re
 

Gave me a syntax error for -h.. Im gonna go back to the begining. Delete everything redownload it all and start from scratch. Maybe I missed a simple task.. we shall see.. I will let you know how it goes.. thanks for the assist


Buck

I had this error too..

Check your db.ini username and password for any white spaces at the end.

If when you see the error it looks like "myuser @localhost" (note the spaces between the @ and the username), then you have spaces in your .ini file.

-Auldar

i had the same problem fixed it by running mysql and the sql server