Error: Client does not support authentication protocol reque

[bpevans]

Running Fedora Core 3,
MySQL 4.1.11

During install I get the following:

Could not connect to database; check your settings.
The mySQL error was: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Database Settings
Here you can enter all your database information. Serendipity needs this to be able to function

I created the db, and my root/passwd are correct for mySql (I can do mysql -p as root@localhost np)

Idea? More to debug?

[mgroeninger]

This is a problem with mysql > 4.1 and php 4.3.x

This link offers some work arounds:
http://dev.mysql.com/doc/mysql/en/old-client.html

Fix that worked for me:

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Specific problem, from the link:

Note: In PHP, the mysql extension does not support the new authentication protocol in MySQL 4.1.1 and higher. This is true regardless of the PHP version being used. If you wish to use the mysql extension with MySQL 4.1 or newer, you will need to follow one of the options discussed above for configuring MySQL to work with old clients. The mysqli extension (stands for "MySQL, Improved"; new in PHP 5) is compatible with the improved password hashing employed in MySQL 4.1 and higher, and no special configuration of MySQL need be done in order to use this newer MySQL client library for PHP. For more information about the mysqli extension, see http://php.net/mysqli.

So you might look at moving to php 5, if you are so inclined... (I still haven't... )

[bpevans]

I rolled back to an earlier version of mysql. And install ran fine.

mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

I attempted the php5 install from source but that didn't fly to far. I'll stick to php4 for now.


Thanks!