Error !

[ryder911]

Ok I get a access denied to mysql database on world.exe when I run it. Yes I tried doing what the post said.

Here is all my information

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=Shadowed Realm(Legit-Custom)
worldaddress=138.89.74.XXX
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=192.168.1.XXX


# READ README.TXT!

[Database]
host=192.168.1.xxx
user=ryder911
password=mysqlusername
database=eq
compression=off


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


REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

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

if NOT exist spells_us.txt goto NOSPELL

start zone . 138.89.xx.xxx 7995 192.168.1.xxx
start zone . 138.89.xx.xxx 7996 192.168.1.xxx
start zone . 138.89.xx.xxx 7997 192.168.1.xxx
start zone . 138.89.xx.xxx 7998 192.168.1.xxx
start zone . 138.89.xx.xxx 7999 192.168.1.xxx
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------



Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[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
Warning: Pants may change during online play.
TCP listening on: 138.89.74.210 :9000
World server listening on: 138.89.74.210 :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
[quote]


And I granted access to ryder911, I tried 2 times. I can access DB with eqadmin and such, but the world.exe wont connect to it. Any help is apprecaited. And I am running DB on the same computer as this one.

[mikenune]

Your host should be "localhost" instead of your IP address.

[ryder911]

I did it in the db.ini and still getting the same problem...=(

[mikenune]

Try running this query:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER ON whatever_your_EQEMu_DB_is.* TO "whatever_your_username_is"@"localhost" IDENTIFIED BY "whatever_your_password_is" WITH GRANT OPTION;

[ryder911]

K, I will try that, and can anyone tell me what the bind address in you my.ini for Mysql is supose to be. I changed it i think, I dont remember, not sure if that might be causing it

[ryder911]

Tried that, It didn't work!=( It is weird though I am able to open the DB with Mysql Front, but it wont run on the world.exe

[mikenune]

When using MySQL-Front, do you log in as the root user or as your equser?

[ryder911]

What do you mean? I log in with mysql username and pword...

[mikenune]

Right, but is that username "root" or is it the one you created for your server? My guess is it's "root."

It definately looks like it's a simple permissions error. I get the same thing when I try to manually create users in MySQL. I've never been able to get it to work without using PHPMyAdmin (which, unless you have a web server with PHP installed on that same box, you can't do).

Tell ya what... Just for giggles try this. It's basically the same thing I told you to do earlier with one extra step at the beginning. . .

USE mysql
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER ON whatever_your_EQEMu_DB_is.* TO "whatever_your_username_is"@"localhost" IDENTIFIED BY "whatever_your_password_is" WITH GRANT OPTION;
Man, if this works, I'm gonna be sooo pissed. . .