Long story short:

You need to set type field in the users table to 3:

update users set type=3 where userid=66;

To change password in MySQL  (tested with 5.0 ):

update users set passwd=md5('mynewpassword') where alias='someuser';