Page 1 of 1
Error: Client does not support authentication protocol reque
Posted: Wed Jun 01, 2005 4:57 am
by 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?
Posted: Wed Jun 01, 2005 5:40 am
by 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...
)
Fixed. Rolled back to mysql 3
Posted: Thu Jun 02, 2005 3:20 pm
by 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!