Posted by "Nalini Pal" on 05/27/05 12:22

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@btinternet.com


-----Original Message-----
From: Jim & Sara Feldman [mailto:feldmans@rcn.com]
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:feldmans@rcn.com]
>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

• Next in forum: Stopping users to see uploaded files
• Prev in forum: novice: how to run .sql script from php?
• Thread view: RE: [PHP] further detail on mysql connect problem

[Reply to this message]