1045,2006 errors and more need help plz
 

Ive been working on a server and when i run world.exe i get this

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.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
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.
Liberating a country that despises us...
TCP listening on: **.***.**.**:****
World server listening on: **.***.**.**:****
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: eqlogin1.eqemu.net:5999


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


[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=TEST here
worldaddress=**********
locked=false
account=
password=

[WorldServer]
Defaultstatus=Unavail
zone=

[LoginConfig]
ServerMode=StandaloneServer
Port=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . *********** 7995 ***********
start zone . *********** 7996 ***********
start zone . *********** 7997 ***********
start zone . *********** 7998 ***********
start zone . *********** 7999 ***********
start zone . *********** 8000 ***********
start zone . *********** 8001 ***********
start zone . *********** 8002 ***********
start zone . *********** 8003 ***********
start zone . *********** 8004 ***********
start zone . *********** 8005 ***********
start zone . *********** 8006 ***********

exit
cls

/me slaps his forehead....

fix
 

try this...

1. go to start
2.click run
3.type this:
C:\mysql\bin\mysql.exe
4.when it opens type:
use eq <-----or whatever your DB name is

5.then type:
GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED
IDENTIFIED BY '%';

if that command doesnt work try changed localhost with 127.0.0.1 or '%' with your mysql name/password. the first '%' being your account name and the second '%' being your password


this worked for me hope it works for you