RE: [PHP] further detail on mysql connect problem

2005-05-27 Thread Nalini Pal 
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

[EMAIL PROTECTED] 
  

-Original Message-
From: Jim & Sara Feldman [mailto:[EMAIL PROTECTED] 
Sent: 27 May 2005 04:41
To: Nalini Pal
Subject: RE: [PHP] 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:[EMAIL PROTECTED]
>Sent: 25 May 2005 01:16
>To: php general discussion list
>Subject: [PHP] 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()." ";
>
>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

Re: [PHP] further detail on mysql connect problem

2005-05-25 Thread John Nichel 

Jim & Sara Feldman wrote:

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()." ";

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


Check the archives/Google/MySQL's site/etc.  This 'problem' has been 
discussed numerous times.


--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] further detail on mysql connect problem

2005-05-24 Thread Richard Lynch 

Google for that error message.

We just discussed it days ago...

I forget what it was, but the answer's in the archives.


On Tue, May 24, 2005 5:15 pm, Jim & Sara Feldman said:
> 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()." ";
>
> 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


-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php