EQEmulator Forums - MySQL user and pass not matching?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)

- - MySQL user and pass not matching? (https://www.eqemulator.org/forums/showthread.php?t=12684)

MySQL user and pass not matching?

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:

Code:

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

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:

Code:

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>>>>:)

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.

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

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

Code:

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:)

you spelled PRIVILEGES wrong....

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

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.

You are probably not getting

Code:

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.

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

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! :D