Error 2006, please help

[Brood]

I get error 2006 with both world.exe and boot5zones. This is what it looks like:


Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[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
Liberating a country that despises us...
TCP listening on: myno-ipaddress.no-ip.info:9000
World server listening on: myno-ipaddress.no-ip.info: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


Now, if it was just a usual error 2006 it would be fine, however, I have a certain un/pw for mysql, and one for this forum. Both of them I have done the grant option thing with, and I have checked and rechecked every time that my winmysqladmin has been up and running all the time, as well as the no-ip program, and the link is up and running. It started when I uninstalled mysql and put it in the proper directory, c:/mysql. I took the MW055_alpha02 database, said:

c:/mysql/bin mysql -u root mysql
Grant all privileges.. my mysql un/pw etc.;
create database eq;
use eq;
source MW055_alpha02.sql;
And it did the correct thing. It created the eq database. Then I made the loginserver.ini look like this:


### --- 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
loginserver=eqlogin2.eqemulator.net
loginserver=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=my servername
worldaddress=myno-ipaddress.no-ip.info
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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



Furthermore my db.ini looked like this:


# READ README.TXT!

[Database]
host=localhost
user=MySQLuser (and believe me, I've checked and rechecked that it was this)
password=MySQLpassword (same as above)
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.


And my boot5zones:


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 . myno-ipaddressno-ip.info 7995 127.0.0.1
start zone . myno-ipaddressno-ip.info 7996 127.0.0.1
start zone . myno-ipaddressno-ip.info 7997 127.0.0.1
start zone . myno-ipaddressno-ip.info 7998 127.0.0.1
start zone . myno-ipaddressno-ip.info 7999 127.0.0.1
exit
cls

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

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


As I've said, it all started after uninstalling Mysql and reinstalling it on c: drive. I did this in order to change my un/pw, that was by mistake the same as the eqemu forum one. I did as a guide told me to do here, uninstall mysql, reboot computer, reinstall, reboot, start up winmysqladmin and give un/pw. I then picked a different one, altered db.ini to say the new ones, and gave "grant option.." th

[FiCtIoN]

open up mysql with -user root like befor but use INSERT INTO ACCOUNT set name='mysqlusername', password='mysqlpass', status=200; REPLACE MYSQLUSERNAME WITH YOUR USERNAME AND MYSQLPASS WITH YOUR PASSWORD

[Brood]

Well... no. Just found the problem. In db.ini I wrote my mysqlusername with a capital letter first, and since it was case sensitive, I guess that was what made the problem :/

[FiCtIoN]

c:/mysql/bin mysql -u root mysql
Grant all privileges.. my mysql un/pw etc.;
create database eq;
use eq;
source MW055_alpha02.sql;
And it did the correct thing. It created the eq database. Then I made the loginserver.ini look like this:


If that is all you done is the grant option and source the DB you will have to set a password and username in your DB via the insert command.

[samandhi]

If that is all you done is the grant option and source the DB you will have to set a password and username in your DB via the insert command. If I am understanding what you are saying correctly, then that is NOT true. When he installed MySQL and then ran winmysqladmin.exe THAT is when he created the UN and PW for use with his DB. The GRANT command simply allows him the proper access to whatever DB he chooses to use in MySQL, with that particular UN/PW instead of having to use -root (which is the default UN without a PW)... The INSERT command is generally used to flag an account for status in game... And this can be accomplished in more than one way.. You could use the INSERT command or you could open a dos prompt and change to the world.exe directory and type:
world flag <username> 200 You could also put in the PW you would want flagged as 200 status....

In other words 'INSERT INTO account' is simply a way of forcing the eq db to make an account before you actually log into the game and do it that way .... It has nothing to do with the UN/PW that is used to access MySQL in general... That is why he got it to work (once he found that he was using caps where he shouldnt have been)... Hope this helps clear some things up a little....:)

[FiCtIoN]

ok im not very good with mysql yet still reading up wasnt very sure on the steps to take but now that i read what you say it makes sense thanks for clearing it up :D

[samandhi]

NP glad to help...:)