Set MD5 password for a user

update users set password = MD5('password') where user_id = 999