World.exe and Boot5Zones Problems

[Echoes]

Now i'm getting error 2005, too many signals on mysql server, plz post answer thx. Boot5zone Says

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-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 zone names
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
[Error] LoadEMuShareMemDLL::Load() failed to load library 'EMuShareMem'. Error=
126
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
[Status] Loading npc faction lists
[Error] LoadEMuShareMemDLL::Load() failed to load library 'EMuShareMem'. Error=
126
[Error] Loading npcs faction lists FAILED!
===============================
Runtime errors:

MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=3

Hit any key to exit

World.exe Says

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-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] Clearing groups..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Unable to clear groups: #2006: MySQL server 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
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10
characters.
[Error] [ChatChannelServer] block not found in ./LoginServer.ini
[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..
Couldn't open './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
You may already be a winner... of the darwin award.
TCP listening on: 67.164.67.38:9000
World server listening on: 67.164.67.38:9000
===============================
Runtime errors:

MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=3

Hit any key to exit

2) In C:\mysql\bin, run mysql.exe

Type into the window:

Code:
GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;



Replace Username with the username you selected above, and Password with the password you selected above.

It should say something like:
Code:
Query OK, 1 Rows Affected, 0.0sec


Note: If you get an error when typing the grant all privileges line:

1) Make SURE you copied the line of code EXACTLY as written and changed username/password. (you need the ''s(apostrophes) around the password. 'example' not "example" or example.)

2) Try opening a command prompt. Type:

Code:
CD C:\mysql\bin


then type

Code:
mysql -u root mysql


And proceed to type the grant all privileges command again.

[Echoes]

Error 1045, access denied for user: '@localhost' <using password: NO>

[Derision]

Originally Posted by Echoes

Error 1045, access denied for user: '@localhost' <using password: NO>

If you are getting that error when doing the GRANT command, run mysql like this:

C:\mysql\bin> mysql -u root

and then type in the GRANT commands.

[Echoes]

I put that in then the GRANT stuff, i got another error but i think im getting closer.

You have an error in your SQL syntax. Check the manual that corresponds to your MYSQL server version for the right syntax to use near 'C:\mysql\bin> mysql -u root GRANT ALL PRIVILEGES ON *.* TO (username) mysql>

Code:
CD C:\mysql\bin


then type

Code:
mysql -u root mysql


And proceed to type the grant all privileges command again.

NOT

mysql -u root GRANT ALL PRIVILEGES ON *.* TO (username)

Also

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

Make sure its exactly like that with the proper username and pasword with the pasword in the quotes like it showes

[Echoes]

Ok, that worked! thank you for helping me there. But when i hit Boot5zone i still get a "there are too many connections on the server and it is overloaded.

[Echoes]

i thought it would help so i installed the PEQ Kunark db, still get same problem with 2005 "the mysql servers are too busy".