Setting up server. MYSQL Is messed up
 

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

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.

Might need to run something like this ;
This will enable password compatibility for 5x with the old 4x binaries

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?

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

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?

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

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.

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

So my zone.exe keeps crashing here is my log file (windows wont let me delete it either lol)


So yeah im gonna drop my database and try resourcing with a new download. Hope this helps. All my installs seem to be ok. I did the SQL updates in the change log also, not sure if I did them correctly. I got some errors lol

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

yeah, i reinstalled windows and im downloading the database via CVS so we will see what happens now

If you use AX_CLASSIC for the first time, then you need to install the full version, then update with the latest "core update" so you get all the newest sql fixes.

Ok I finished reformatting and re installing. Everything is working except zone.exe is crashing. Im gonna get the log file and past here. I am using PEQ database also. So any help will be greatly appreciated. I will search the forums for the answer in the mean time.

Ok there are no errors in the log file as far as I can tell so ill post it here.
World

part 2 coming

AH HA

lol im stupid, please delete this thread and my other one. Sorry bout this guys