upgrade mysql client ( linux )

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
biker007fr
Forum Newbie
Posts: 14
Joined: Thu Jun 09, 2005 7:11 am

upgrade mysql client ( linux )

Post by biker007fr »

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 »

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 »

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 »

If i'm not mistaken it was a matter of UPDATE password...
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

the new password was a pain in the arse for me when i upgraded

http://dev.mysql.com/doc/mysql/en/old-client.html
biker007fr
Forum Newbie
Posts: 14
Joined: Thu Jun 09, 2005 7:11 am

Post by biker007fr »

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 »

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 »

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
Post Reply