We have just moved to a new web server where we are running mysql version: 5.0.45

["Malka Cymbalista" <Malki.Cymbalista@xxxxxxxxxxxxxx>]

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
malki.cymbalista@xxxxxxxxxxxxxx
08-934-3036



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx