MySQL user and pass not matching?

[corylovely2002]

I keep getting this same error message everytime I run world.exe, no matter how many times I change the user and password. Anyone know how to fix it? I have tried twice starting from scratch and it still isn't working.

World.exe output:

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[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
Please don't make me a levelme server. :(
TCP listening on: 192.168.14.1:9000
World server listening on: 192.168.14.1: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

[samandhi]

Do you remember the UN and PW you used when you ran winmysqladmin.exe for the first time? You will need this.. then open up a dos command window and type the following, where username is the username from winmysqladmin.exe, and password is from the same:

cd c:/mysql/bin
mysql -u root mysql
GRANT ALL PRIVELEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
quit

Note the single quotes around the password ARE needed here...

If you cant remember the UN and PW you assigned when you first ran winmysqladmin.exe then open up windows explorer or mycomputer and browse to c:/windows and find the file my.ini and delete it.. Now browse to c:/mysql/bin and run winmysqladmin.exe and it will ask you for a UN and PW... type one in there and remember it.. NOW do the GRANT command again from above and you should be all set... Hope this helps>>>>

[devn00b]

Looks to me like mysql is shitting itself on yer pc. ininstall it (delete C:\mysql) and remove C:\<windir>\my.ini and reinstall from scratch.

[samandhi]

/off topic ROFL ... like your avatar /dev/noob good for ummm st. patty's day yeah....:p

[corylovely2002]

Well, I reinstalled mysql and it still didn't work. So I tried that grant priveleges thing and I get this response back.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVELEGES ON *.* TO admin@localhost IDENTIFIED BY 'pass' WITH
GRANT OPTION;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'PRIVELEGES O
N *.* TO admin@localhost IDENTIFIED BY 'pass' WITH
mysql>

I don't know what any of that means, this is my first time using mysql and so far I don't like it

[Spike]

you spelled PRIVILEGES wrong....

Therefore the mysql database couldn't recognize the command...

[corylovely2002]

I just left PRIVILEGES out and it worked, but now my server isn't showing up, but I saw someone else having that problem before, so I will check other threads. Thanks all for the help, really appreciate it.

[nilar]

You are probably not getting

 Connected to Loginserver:eqlogin1.eqemulator.net:5997

at the end of your world.exe.

This means something is wrong with your loginserver.ini. Make sure there are no spaces after any lines and if your getting an error in world.exe then you will need to fix that.

[NarutoLegacy]

Also make sure you didnt delete anything important, like I did at first, lol

[corylovely2002]

Well, got the server to show up, but now I get the all too popular 1017. Back to the drawing board I guess. For all the hassle, this is actually kind of fun!