Page 1 of 1

Upgrading MySQL Clients

Posted: Mon Nov 15, 2004 11:53 am
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.

Posted: Mon Nov 15, 2004 11:56 am
by Grim...
Some more info would help:

Running on WinXP with Apache 2.0.52, PHP 4.3.9 and MySQL 4.1.

Posted: Mon Nov 15, 2004 12:45 pm
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

Posted: Tue Nov 16, 2004 8:24 am
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).

Posted: Tue Nov 16, 2004 8:47 am
by timvw
are you sure that you are using mysqli_ functions instead of mysql_ ?

Posted: Tue Nov 16, 2004 9:37 am
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.

Posted: Wed Nov 17, 2004 9:30 am
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).

MySQL is not comunicating with PHP no localhost connection

Posted: Sun Dec 05, 2004 5:28 pm
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 :?: