authentification protocol, upgrade client

[wood1e]

Hi,

I have installed PHP4 with MySQL4 and APAche2. Apparantly with an API client 3.23.49 I need to upgrade as MySQL is on 48 bit password and not 16...I keep getting " mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in..."

How do I upgrade this client? As even the solution on MySQL mentions doing this as one solution. And every time I try their hashing solutions I can't get into MySQL at all...obviously doing something wrong

SO thought I would try and find out about upgrading client...so they mean PHP5? Is there any problems in doing so?

[Malcolm]

You can:
1) Downgrade MySQL to 4.0.*
2) Upgrade to php5 and use the mysqli functions
3) When creating accounts use the OLD_PASSWORD function.

http://dev.mysql.com/doc/mysql/en/old-client.html

[wood1e]

Hi, Many thanks, would downgrading to MySQL 4.0 cause any problems? Or should I go for MySQL3.23 ?

OR is it just simplier to go for PHP 5? Do scripts written for PHP4 run ok?

[Malcolm]

Going to MySQL 4.0 would probably be easiest. You're only going to be missing some new security options and some transactional support going back to 4.0, but it shouldn't make a real difference for a home deveolpment server.

[wood1e]

many thanks will look into that...