BOLVERK – Tim's Lousy Blog

I’ve had to look this up far too many times to not document it now. For user with user_id 1, execute the following on MySQL.

UPDATE user SET user_password =
md5(CONCAT('1-',md5('newpassword'))) WHERE user_id = 1;

or this for Postgres.

UPDATE user SET user_password =
md5('1-' || md5('newpassword')) WHERE user_id = 1;