Well I thought everything was right.. Get this

[buck]

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

[Trumpcard]

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

[buck]

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

[Trumpcard]

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

[buck]

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

[Trumpcard]

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.

[buck]

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

[Auldar]

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

[houdini]

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