SQL Error: Authentication Outdated (MySQL 4.1)

Halamafx · #1 09-06-2007, 08:51 AM

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

Bakersman · #2 09-07-2007, 05:53 AM

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 · #3 09-07-2007, 11:32 AM

Quote:

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,

Code:

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

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

Halamafx · #4 09-08-2007, 01:22 AM

ya i know old thread lol.. anyhow.. shows im using the search feature ^_^ now its saying my pw incorrect lol.. damn :(

Halamafx · #5 09-08-2007, 01:31 AM

ok heres whats going on.. when i do that old pw line on mysql.. it tells me Access denied for user 'eq'@'localhost' (PW wrong).. I try to figure out what it is manually.. and no idea.. keeps saying PW wrong.. when i go to Mysql admin to change the PW.. it says alrighty then! But.. Authentication protocol not supported.. back to square 1.. any clue?