Hey Juice, long time
It depends what way it's encrypted, usually the two most common ways are going to be MySQL's default password function or md5, in which case you can do either of:
UPDATE table SET password=PASSWORD('newone') WHERE user='juicy';
or
UPDATE table SET password=md5('newone') WHERE user='juicy';