Zikula Community

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\chris\pnadodb\drivers\adodb-mysql.inc.php on line 339
Error connecting to DB
Program: c:\inetpub\wwwroot\chris\install\db.php - Line N.: 45
Database: chris
Error (1251) : Client does not support authentication protocol requested by server; consider upgrading MySQL client
connect string: mysql://*****:******@localhost/chris error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have mysql-4.1.8 I used this database before what could be the problem?
I also have service pack 2 on the computer with all the firewalls turned off.

Pls forgive me my poor english, here is what you can do:
1. Login as root to mysql at the command prompt (in windows XP sp2 select from menu start->programs->mysql->mysql command line)

2. create new account for example ‘zoooz:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'zoooz\@\localhost';

3. set password in old format:
mysql> SET PASSWORD FOR 'zoooz\@\some_host' = OLD_PASSWORD('mypass');

if you are running PostNuke on local machine use ‘localhost’ as host name
And that’s all.

The reason you get the error message is that MySQL 4.1 uses an authentication protocal based on a new password hashing algorithm that is not apparently supportet by PHP (or apache?). Command old_password assigns password with old algorithm

Zoooz

The alternative is to ensure that PHP is the latest version as they support the newer mysql authentication protocol. Given the recent security annoucement surrouding earlier PHP revisions then there is no reason you should be using anything but the latest revision of PHP anyway.

-Mark