problem with username and password in sql
 

when i run boot5zones it always tells me that the username and password has been rejected. I tried re entering the line:

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

many times but it just doesn't work. can someone help me?
This is what my boot5zones look like when i run it.

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.2-DR1
[Status] Loading opcodes..
[Status] Mapping Opcodes
[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
[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(*),sum(length(serialization)+
1) FROM items' #2006: MySQL server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetNPCFactionListsCount query 'SELECT MAX(id), count(*) FROM npc_factio
n' #2006: MySQL server has gone away
Error: Database::LoadNPCFactionLists-ShareMem: GetNPCFactionListsCount() returne
d < 0
[Error] Loading npcs faction lists FAILED!
===============================
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

Man..I know what you mean..I have been meaning to write a comment about that in wiki 6.2 tutorial.
If you are getting a syntax error when doing the grant thing..Then try this way...
GRANT ALL PRIVILEGES ON eqdr2.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

Notice how the name of Database(eqdr2) is written..This way works for me.

those errors are not from a failed login and password. looking through them i would say you are not useing Velious RC1 database.

This is one error i see when people say that they followed the tut and it don't work. You will not get this error useing Velious RC1 Database.If you compiled the latest source release you will have to source in a few lines to fix RC1 and they are posted on PEQ sight.

EDIT:
he can only put it in that way if he name his database eqdr2. Also i have never had an issue useing *.* in that string for any of the DB's i haved used.
so i will still say he is using the wrong DB for 6.2 or something went screwy louy with his Database.

Yep..You are right on the Datbase thing.I didnt notice the items errors I jumped into the grant thing cause I did this the other day and was writing it(Im just using test as name of Database)
*test* then I went to sesmars tut and he wrote it test.* Now I see I could have also wrote *test.* and that should work to..Thanks.

The *.* will grant root privilages to all databases , instead of identifying one.

Also please remember that when it says to input

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

That you have to replace Username with your username , and password with your password. So basically it would look like ..

GRANT ALL PRIVILEGES ON *.* TO Bob@localhost IDENTIFIED BY 'Smith123' WITH GRANT OPTION;

I use my username and password and hit enter. The response is:

Query OK, 0 rows affected (0.00 sec)

Doesn't that mean it didn't do anything?

Thats good, don't forget to put your name and password in db.ini :)