RE: [PHP] further detail on mysql connect problem

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' = mysql> 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