Originally Posted by Varius

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

Originally Posted by directfiesta

you need to repace it with an encrypted password ( MD5)

http://md5encryption.com/

Originally Posted by Domain Broker

change the varchar to md5