Setting up server. MYSQL Is messed up

[Astaldoath]

Ok dont ask me how but some how mysql is messed up. It will not allow me to change the root password. When I sourced my peq database It give me a few warnings, no errors. I followed the guide exactly, its my 3rd re install trying to get it to work. It worked the first time but I dropped my database in navicat because tables were missing data. Now my server cannot connect to the database. Please help me, im not a noob ive done this before with a different guide about 1 year ago. Thanks

Error btw

---------------------------------------------
[01.24. - 03:07:00] Starting Log: logs/eqemu_error_zone_3876.log
[01.24. - 03:07:00] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am using the MYSQL 5.0.45

[sesmar]

Originally Posted by Astaldoath

Error btw

---------------------------------------------
[01.24. - 03:07:00] Starting Log: logs/eqemu_error_zone_3876.log
[01.24. - 03:07:00] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am using the MYSQL 5.0.45

I am not sure what version of MySql the precompiled binaries are compiled against but I believe that it is still MySql 4.x not 5 so that would be the reason for the error you are getting here. You can either start using MySql 4.x or compile your own binaries against your version of MySql.

[Angelox]

Might need to run something like this ;

SET PASSWORD FOR 'eq'@'localhost' = OLD_PASSWORD('newpwd');

This will enable password compatibility for 5x with the old 4x binaries

[Astaldoath]

ahh, so should I actually use mysql 4.whatever not 5, ive had nothing but trouble trying to use 5 but thats what the new guide says. If so what version of perl should I get?

[Astaldoath]

If someone can help me get this running correctly im gonna edit the wikki. The guide now does not work and thats probably why everyone is having so many problems. I would love to get a hold of techguy

[Astaldoath]

Originally Posted by Angelox

Might need to run something like this ;

SET PASSWORD FOR 'eq'@'localhost' = OLD_PASSWORD('newpwd');

This will enable password compatibility for 5x with the old 4x binaries

so angelox should I be using 5.0.45 or 4.xxx. I saw you congradulated that guy on the guide so it must be working right?

[Xgen]

Originally Posted by Astaldoath

If someone can help me get this running correctly im gonna edit the wikki. The guide now does not work and thats probably why everyone is having so many problems. I would love to get a hold of techguy

The pdf guide? It worked just fine for me a few days ago using mysql 5.x