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
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.
Webmaster, Weizmann Institute of Science