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.
--
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
