world.exe prbs error: 1045
 

ok first ... i have read .. and re-read ,,, and re-re-read !!! all the manueals and posts related to this prob! so dont tell me to go read the freakin manuals or do a search for the answer and read the post .... i already have ok!


now , that THAT is out of the way, here is the prob im haveing.



login name and passwords are marked out with a (#) sign !

##########################################

C:\EQEmu>world
Failed to connect to database: Error: #1045: Access denied for user: '########
@127.0.0.1' (Using password: YES)
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
Loading Variables, zone names & items...
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
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
EMuShareMem.dll 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
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data

##########################################

i know there are at least 4 diff post that i can remember off the top of my head that each give a way of fixing this with differant syntex's of the GRANT command .... i have tried them all !!!

SYSTEM INFO :

os : win xp
eqemu version : EQEMu-0.4.3
connecting to eqlogin.eqemu.net


DB.INI FILE
# READ README.TXT!

[Database]
host=localhost
user=########
password=#######
database=C:\mysql\data\eq

### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

I dont want to be rude man, but if you searched and didnt find the solution, you didnt search very hard...

There are about 20 posts on this exact error monthly..

do a search on 'grant all privileges'

I believe its also a sticky thread in one of the support forums....

*edit* its in this support forum, where you posted :P Try re-re-re-reading... But try harder :D

*edit #2*
Try the sticky thread in this forum, maybe you looked at a GRANT command that was typed wrong, or maybe you typed it wrong, because it does work. Also try restarting the computer after you find it and do it.

ok now that i have that part fixed
 

ok now i get this part messed up ... as always i have been reading post all day , dont know what i did to fix the last problem (or even if its fixed at all) here is the problem im getting from world.exe now

##########################################

Failed to connect to database: Error: #1102: Incorrect database name 'c:\mysql\d
ata\eq'
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Loading Variables, zone names & items...
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
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
DEBUG START
DEBUG:0
DEBUG:0
DEBUG:0
EMuShareMem.dll 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
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data. But ignoring
...done.
LoginServer.ini read.
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
done.
Loading EQ time of day..."./eqtime.cfg" is NOT a vaild EQTime file. File version
is 0; EQTime version is 1000 - failed.
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Deleted -1 stale player corpses from database.
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Deleted -1 stale player backups from database.
Assassinating people that whine about horses...done
TCP listening on: port 9000
World server listening on: port 9000
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone
away'
Connected to LoginServer: eqlogin2.eqemu.net:5999
Login server responded with FatalError. Disabling reconnect.
Error message: 'Bad server name. Unknown reason.'
64.81.113.122:5999: TCPConnection::RecvData(): Error: 10053

##########################################

as always your help is appreciated :)
tia