Hi Jim,
MySQL have changed the password hashing in version 4.1
Go to your mysql command prompt. If you are using windows you can find it
from
Start > MySQL > MySQL Server 4.1 > MySQL Command Line Client.
Or something like that...
Type the following, replacing your values for "some user", "some host" and
"my pass":
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');
Here is the mysql doc for it:
http://dev.mysql.com/doc/mysql/en/password-hashing.html
I spent ages trying to work this one out, hope this helps..
Have you downloaded mysql administrator?
Best wishes
nalini
nalini.pal@xxxxxxxxxxxxxx
-----Original Message-----
From: Jim & Sara Feldman [mailto:feldmans@xxxxxxx]
Sent: 27 May 2005 04:41
To: Nalini Pal
Subject: RE: further detail on mysql connect problem
Nalini:
Thanks. I installed PHP5 and got by the mysql_pconnect()
issue. That got me to the effort to compare a login with stored data.
No match. I am wondering if MySQL has changed the password
translation algorithm. I suspect that once I have unraveled that
mystery, all that worked before will work again.
Again, many thanks.
Jim
>Hi Jim
>I had the same problem a couple of weeks ago. After much searching I found
>this solution that worked for me:
>
>http://forums.mysql.com/read.php?11,6400,10611#msg-10611
>
>Hope that helps
>Nalini
>
>-----Original Message-----
>From: Jim & Sara Feldman [mailto:feldmans@xxxxxxx]
>Sent: 25 May 2005 01:16
>To: php general discussion list
>Subject: further detail on mysql connect problem
>
>Hi:
>
>Adding a detail to my previous note on the mysql connect problem:
>
>At the point where I attempted to connect, I added a printout of the
>error generated when the instruction ran. The two lines now read:
>
>$result = mysql_pconnect("localhost", "api_user", "x97533");
> echo "Tried to connect. Problem: ".mysql_error()." <br>";
>
>What came back was:
>
>Tried to connect. Problem: Client does not support authentication
>protocol requested by server; consider upgrading MySQL client
>
>Thanks for your help.
>
>Jim
>--
>Jim Feldman
>14 Linda Lane
>Newton, MA 02461
>
>617-527-0509
--
Jim Feldman
14 Linda Lane
Newton, MA 02461
617-527-0509
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
