Page 1 of 1

authentification protocol, upgrade client

Posted: Sun May 22, 2005 5:52 pm
by 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?

Posted: Sun May 22, 2005 8:26 pm
by Chris Corbyn
That's not specific to PHP it's when you try and connect using an old client (i.e. the command line mysql client will do the same).

Switch to mysqli_connect() if you can, that should fix it :wink:

Posted: Mon May 23, 2005 1:45 am
by timvw
The question has been answered in the MySQL FAQ. (And a few times in this forum too...)