List:General Discussion« Previous MessageNext Message »
From:Malka Cymbalista Date:April 9 2008 1:54pm
Subject:Re: We have just moved to a new web server where we are
View as plain text  
Thanks to Martin and Paul for their answers.  
-- 

Malka Cymbalista
Webmaster, Weizmann Institute of Science
malki.cymbalista@stripped
08-934-3036


>>> On 4/9/2008 at 3:54 PM, in message
> <p06240800c4226cd728a4@[192.168.1.35]>, Paul
DuBois <paul@stripped> wrote:
> At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote:
>>We have just moved to a new web server where we are running mysql 
>>version:  5.0.45
>>On the old machine, when we gave the following command:
>>update table1 set passwd = password('xx') where user_name="xx";
>>
>>and then gave the following command,
>>SELECT user_name FROM alon_protein_passwd WHERE (user_name = "xx" 
>>AND passwd=password('xx'))
>>
>>we got the expected results.
>>
>>Now when we do this, on the new machine, we get no result i.e. Empty set.
>>
>>Any help will be appreciated.
> 
> The password hashing algorithm changed in MySQL 4.1.  You can read about
> it here:
> 
> http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html 
> 
> This is likely the cause of the changes that you're observing.  I
> imagine that you'll either need to upgrade the passwords in your
> table, or look for them using OLD_PASSWORD() rather than PASSWORD().

Thread
We have just moved to a new web server where we are runningmysql version: 5.0.45Malka Cymbalista9 Apr
  • RE: We have just moved to a new web server where we are runningmysql version: 5.0.45Edward Kay9 Apr
    • RE: We have just moved to a new web server where we arerunningmysql version: 5.0.45Malka Cymbalista9 Apr
  • Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45Martijn Tonies9 Apr
    • Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45Malka Cymbalista9 Apr
  • Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45Martijn Tonies9 Apr
    • Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45Malka Cymbalista9 Apr
  • Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45Martijn Tonies9 Apr
  • Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45Martijn Tonies9 Apr
  • Re: We have just moved to a new web server where we are running mysql version: 5.0.45Paul DuBois9 Apr
    • Re: We have just moved to a new web server where we arerunning mysql version: 5.0.45Malka Cymbalista9 Apr