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';
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';