Architecture / Installation

Posted by bzahn 05 Dec 2006 01:00 GMT-0000 posts: 96

> This weekend I upgraded my MySQL from 4.1 to 5.0.27. That immediately broke my Tiki site (v. 1.9.3.1).
>
>
> First error message I get is:
>
> TikiWiki is not properly set up:
> Unable to connect to the database !
> Go here to begin the installation process, if you haven't done so already.
>
> Client does not support authentication protocol requested by server; consider upgrading MySQL client
>
>
>
> When I click on the link to begin the installation process, I fill in everything as usual, then I get:
>
> Client does not support authentication protocol requested by server; consider upgrading MySQL client
> default
> reload
>
> Tiki cannot find a database connection
> Please enter your database connection info
>
>
>
> I just upgraded MySQL so I'm not sure why it's asking me to do so. What did I do and what do I need to do to fix it?
>
> TIA!

I found my answer on the IIS troubleshooting page. Don't know how I missed it. I'll give it here in case it helps someone else.

MySQL Client Error
Error Message:Client does not support authentication protocol requested by server; consider upgrading MySQL client

This happened to me with MySQL 5.03 and PHP 4.3.10. The problem is the
password hashing algorhythm changed. You can make MySQL use the old
one with this command run from the Query Browser.
Note: "TikiPassword" is whatever the password you set was.

SET PASSWORD FOR 'tikiuser'@'hostname' = OLD_PASSWORD('TikiPassword');