Upgrading MySQL Clients

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
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Upgrading MySQL Clients

Post by Grim... »

I posted this a couple of days back, but it seems to have vanished?
I've looked really hard but I can't find it, so I'm posting it again - sorry if I'm just being dumb.

Anyway.

I recently upgraded my PHP, Apache and MySQL versions, and now when I try to connect via PHP to a database, I get this error

Code: Select all

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
According to phpinfo(), my client is

Code: Select all

Client API version 	3.23.49
I've found some help on the MySQL site, but I don't understand what it's saying, and Google has been no help.

So my question is: How, in simple terms, do I upgrade PHP's MySQL client?

Cheers.
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

Some more info would help:

Running on WinXP with Apache 2.0.52, PHP 4.3.9 and MySQL 4.1.
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

Massive respect to my half PC/half human cousin who knew the answers, which I will put here in case anyone else has this problem...

1. Copy the file 'php4ts.dll' from your PHP folder into windows/system32 (overwrite whatever is in there)
2. Restart apache
3. That's it!

:D
User avatar
MarK (CZ)
Forum Contributor
Posts: 239
Joined: Tue Apr 13, 2004 12:51 am
Location: Prague (CZ) / Vienna (A)
Contact:

Post by MarK (CZ) »

Same problem here.

But I had php4ts.dll in windows folder also before that...
So problem remains.
Does upgrade of PHP solve this? (I've upgraded only MySQL).
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

are you sure that you are using mysqli_ functions instead of mysql_ ?
User avatar
MarK (CZ)
Forum Contributor
Posts: 239
Joined: Tue Apr 13, 2004 12:51 am
Location: Prague (CZ) / Vienna (A)
Contact:

Post by MarK (CZ) »

Does it solve the problem? Where can I enable them if they're not working? Upgrade PHP or just use some extension? (I'm using Win, PHP 4.3.3)

Is it at least possible to work with MySQL4.1 while not using PHP 5? I mean without converting passwords to the old format.
User avatar
MarK (CZ)
Forum Contributor
Posts: 239
Joined: Tue Apr 13, 2004 12:51 am
Location: Prague (CZ) / Vienna (A)
Contact:

Post by MarK (CZ) »

Anyone else having this problem?
MySQL4.1+ uses new password hashing system and thus older clients doesn't work.
I've found out that running server with '--old-passwords' should fix the problem (and it does for one linux server I'm using). But it seems that it doesn't have any effect on my Win machine.

Can anyone help plz?

EDIT: Seems working now (at least logging in, the new encoding features messed up most of my db applications).
User avatar
Raz
Forum Newbie
Posts: 4
Joined: Sun Dec 05, 2004 5:20 pm
Location: Romania

MySQL is not comunicating with PHP no localhost connection

Post by Raz »

MySQL is not comunicating with PHP on my testing localhost. The mysql server is ok but i get a "cannot connect to database" and stuff or from another interogation "mysql_connect(): Can't connect to MySQL server on 'localhost' (10061)"

I'm using win XP, apache 2.0.49, mysql 4.1.7, php 4.3.6 !!!

Can somebody help me? I'm realy stuck :?:
Post Reply