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().

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to