Something Strange Indeed.

[nuke_m_good2]

Ok, I have setup about a dozen EQEmu servers in my time, and have used MYSQL and the associated DB's that are availble to EQEmu for quite a while, when i installed the latest version of EQEmu and tried to run World.exe i got an unexpected error that i cannot seem to correct...I checked and rechecked my user / pass in both db.ini and my.ini at least 10 times to verify they are the same...they are. None-the-less i still got all this junk when I run world.exe.

Any Ideas?

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: 128.211.190.180:9000
World server listening on: 128.211.190.180:9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1

Hit any key to exit

Seems to me like its dropping over and over. I have no idea why. I am using MySql latest stable version.

Thanks for lookin at this

- Nuke

looks like you didnt do the grant command in Mysql.

[nuke_m_good2]

INSERT INTO account SET name='eqemu', password='eqemu', status=200;

Where 'eqemu' is my account / pass?

I inserted this by doing the standard

use eq;
INSERT INTO account SET name='eqemu', password='eqemu', status=200;

It did it, and then i tried using world.exe and got the same screen / errors as my first post. when i tried using the

world adduser eqemu eqemu 200 -- i got this instead. Says mysql has "gone away" again.

C:\EqEmu>world adduser eqemu eqemu 200
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
Account Attempting to be created:eqemu 200
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in CreateAccount query 'INSERT INTO account SET name='eqemu', password='eq
emu', status=200, lsaccount_id=0;' #2006: MySQL server has gone away
database.CreateAccount failed.

I tried doing the Grant all access as posted in the sticky, here's what happened:

mysql> use eq;
Database changed
mysql> GRANT ALL PRIVILEGES ON eq.* TO someid@"%"
-> IDENTIFIED BY 'somepass' WITH GRANT OPTION;
ERROR 1044: Access denied for user: '@localhost' to database 'eq'

I'm getting sorta confused about now :(

- Nuke

ERROR 1044: Access denied for user: '@localhost' to database 'eq'

you need to get that fixxed, there is a lot of diferent ways to do the command some work for some others work for other people, search the forum for the diferent ways to do this till you find one that works.

[nuke_m_good2]

I used the

mysql -u root mysql to fix the problem with mysql, thanks

- Nuke