My server suddenly stoped working

[ChaosSlayer]

My server suddenly stoped working overnight.

Last night i shut it down and went to sleep, today I am geting:


when runign world.exe

---------------------------------------------
[06.07. - 18:02:24] Starting Log: logs/eqemu_debug_world_1268.log
[06.07. - 18:02:24] [WORLD__INIT] Loading server configuration..
[06.07. - 18:02:24] [WORLD__INIT] Log settings loaded from log.ini
[06.07. - 18:02:24] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[06.07. - 18:02:24] [WORLD__INIT] Connecting to MySQL...
[06.07. - 18:02:24] [WORLD__INIT_ERR] Cannot continue without a database connection.
[06.07. - 18:02:24] Starting Log: logs/eqemu_error_world_1268.log
[06.07. - 18:02:24] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client



from what I understand its unable to conect to peq DB, and ist password related. I went into eqemu_config.xml
and changed user name to some junk like "bla-bla" and error message came back diffirent, said that this user id is invalid. So its defently the password.
But password setting is identical to all other programs i am running

I run my mySQl query browser - and it works
I check all other editors I have like kayot db editor, Item editor etc (they all requre Db conection user name and password) - they all work

any ideas?
once again it stoped working overnight - nothing was changed that I know off while i was sleeping..

[jimbabwe]

best info I could find on the error
http://www.webyog.com/faq/23_58_en.html

Did you ever run this query when you installed mysql?

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

[ChaosSlayer]

ahh i got it.
thanks for giving me that link to mysql page
now i understand what happened.

yes i did set up password excatly like this in the begining, but yesterday i was messing aroudn with my DB and changed the password for like 5 min (while server was allreday running, so i guess why it was not affected)
and changed it back using NEW sql command which converted password into something unreadable by older sql build (which is what server is based off)

I simply re-run the command you gave me with excatly same password and it converted password to old format and server runs again =)

BIG THANKS =)

[jimbabwe]

I aim to please.