SQL Error: Authentication Outdated (MySQL 4.1)

[fathernitwit]

4.1 works fine, you just have to re-build eqemu yourself. 5.0 has problems however.

[daemonreaver]

Bleg.. MySQL 5x has issues with everything lately, I run it for test only.

As far as building the binaries.. Would VC++ 6.0 be capable (haven't had it installed for a while lol).. Or should i pick up VS 2005?

I think I have the C libs for 4.1 somewhere in my MySQL dirs (too many SQL's installed!) lol.

So far, 0.6.6 runs nicely (once I added the missing guild tables by hand), just have an issue with the loginserver (another thread lol)

[Belfedia]

I update mysql 4.0 to 4.1 and i have same problems before use this help guide :
http://www.webyog.com/faq/23_58_en.html
Now That work

[daemonreaver]

whoah...

Wouldn't you know, OLD_PASSWORD() wasn't in the docs for 4.1!

Thanks a ton.. I'll reset the PW for the game admin SQL hehe.

-editio-

FYI: Worked perfectly. Funny how it's the simple things (that are undocumented) that are at fault.

[Halamafx]

can someone explain this in dumbed down terms for me plz? im having this problem and would really like to fix it

[Bakersman]

well this is the wiki setup, and it has the command lines you need to put into the setup of your mysql database, if this helps any


MySQL Setup

http://www.eqemulator.net/wiki/wikka...kka=MySQLSetup



EQEmulator Database Schema

http://www.eqemulator.net/wiki/wikka...DatabaseSchema

[techguy84]

04-15-2006, 06:33 PM

Holy necro threads Batman!!!

But yea, as Bakersman said, you need to run a sql query to make MySQL 5 work with authencation from MySQL 4 apps, which of course is the emulator.

So you understand fully, open up your MySQL Command Line Interface, and type in the following,

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');

Substitute newpwd with the password you used when running the MySQL Server Instance Config Wizard.