Setting up server. MYSQL Is messed up

[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

[Astaldoath]

Originally Posted by Xgen

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

did you use 5.0.45 or 5.0.37, It works for me with 37 not 45. Im back to square one. Where are the variables in the database located now :( not in variables.sql ruletables or rule sets :( This was my whole problem in the beginning, now I cannot set my xp motd ect.... Not sure if the version of PEQ i got is messed up or what

[Xgen]

Originally Posted by Astaldoath

did you use 5.0.45 or 5.0.37, It works for me with 37 not 45. Im back to square one. Where are the variables in the database located now :( not in variables.sql ruletables or rule sets :( This was my whole problem in the beginning, now I cannot set my xp motd ect.... Not sure if the version of PEQ i got is messed up or what

Ah, your using PEQ, I did the setup using the Angelox database.

[Angelox]

Most of us use 5x, There's no big problem with 5x, void the password fix which is easy too.
You can probably get quicker answers to your questions using the search feature on these forums.

[Astaldoath]

I did search around. I didnt find any relevent answers. 99% of the thread ended with the user fixing his own problem and no actual fix posted