j
k
j a
j l
UPDATE user SET user_password = MD5(CONCAT(user_id, '-', MD5('yourpassword'))) WHERE user_name = 'username';
yourpassword == the password you want username == the username to act on
tested and works in phpmyadmin
Back to the thread
Back to the list