authentification protocol, upgrade client

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
wood1e
Forum Newbie
Posts: 7
Joined: Tue Oct 05, 2004 11:39 am

authentification protocol, upgrade client

Post 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?
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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:
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

The question has been answered in the MySQL FAQ. (And a few times in this forum too...)
Post Reply