Reset a wiki user password

Reset a wiki user password Organic Design procedure

You need to log in to the database directly. Then obtain the user's id as in the following example (alternatively, go to Special:Userlist and get the id from there):

    SELECT user_id FROM prefix_user WHERE user_name='user';

Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222):

    UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;