setting md5 password

  update USERS set password = md5('password') where user = 'user1';