NYCPHP Meetup

[Peter Sawczynec]

This one hit kept me up once awhile ago, so just to clarify quickly: 
MySQL prior to 4.1 was using a smaller encryption on the password field
inside the database.

So when you run the query:
SET PASSWORD FOR root @ localhost = OLD_PASSWORD('root_current_pwd');
... now root's pwd is saved the older way.

Additionally, if you look further you can startup MysQL with a switch to
make the entire db 
use the old password encryption style.

peter


-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Rolan Yang
Sent: Friday, March 31, 2006 1:44 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Mysql Client Version Wrong.


update the password for the mysql user using old_password('yourpassword').
Here is more info: http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Hans Kaspersetz wrote:
> I have a windows xp box with php4 on apache 1.3 and php5 on apache 2 
> and
> the db is MySQL 4.1.  When I start the php5 apache phpinfo reports 
> Client API version 4.1.18.  When I start php4 and Apache 1.3 phpinfo 
> reports Client API version 3.23.blah.  I can not figure out how to 
> update my client version for the php4 instance.  When I try to connect 
> to the 4.1 db with the php it complains about the wrong client.  There 
> was at some point 3.23 on this box, but that was ages ago.  Any ideas?
>
> Thanks,
> Hans
>
>   
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
New York PHP Conference and Expo 2006
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php