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

Re: [PHP] further detail on mysql connect problem

2005-05-25 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(). 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


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

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


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

[PHP] further detail on mysql connect problem

2005-05-24 Thread Jim Sara Feldman 

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