Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
biker007fr
Forum Newbie
Posts: 14 Joined: Thu Jun 09, 2005 7:11 am
Post
by biker007fr » Fri Jun 10, 2005 8:51 am
Hi everyone!
I would like to know how I can upgrade mysql client to bypass the "Client does not support authentication protocol" error while executing a mysql function in PHP.
N.B: I would like to upgrade and not use my old client with OLD_PASSWORD() function.
Thanks
jayloo
Forum Newbie
Posts: 11 Joined: Tue Jun 14, 2005 1:28 pm
Post
by jayloo » Tue Jun 14, 2005 1:57 pm
On linux....
You could install the mysql database as per the directions on mysql.com then you have to recompile php to include mysql support.
Most of this all depends on your OS, version of PHP and version of mysql needed.
biker007fr
Forum Newbie
Posts: 14 Joined: Thu Jun 09, 2005 7:11 am
Post
by biker007fr » Wed Jun 15, 2005 3:14 am
That is what I've done... but after recompilation mysql client 3.23 is still here...
timvw
DevNet Master
Posts: 4897 Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium
Post
by timvw » Wed Jun 15, 2005 5:34 am
If i'm not mistaken it was a matter of UPDATE password...
biker007fr
Forum Newbie
Posts: 14 Joined: Thu Jun 09, 2005 7:11 am
Post
by biker007fr » Wed Jun 15, 2005 8:16 am
No I don't want to solve the problem with the OLD_PASSWORD function. I would like the mysql 3.23 client to become a mysql 4.1 client. I've searched in Google but noone detailed how it could be done...
timvw
DevNet Master
Posts: 4897 Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium
Post
by timvw » Wed Jun 15, 2005 10:09 am
Meaby you need to read the note again...
malcolmboston
DevNet Resident
Posts: 1826 Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK
Post
by malcolmboston » Wed Jun 15, 2005 10:11 am
biker007fr wrote: the mysql 3.23 client to become a mysql 4.1 client.
That doesnt make sense? you want to upgrade it to 4.1? the link i gave you is the only hurdle to do this