RE: further detail on mysql connect problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux