How to change a user’s password in Mediawiki

If you have a wiki you may need to change a user’s password from time to time; you can do this from the back end quite easily. First, access mysql:


mysql -u root -p


Log in using your root password. Next, list your databases:


show databases;


On our test system this shows all of our databases like so:


mysql> show databases;
| Database
| information_schema
| mysql
| performance_schema
| press
| test
| wiki
6 rows in set (0.10 sec)

Select your wiki’s database:


USE wiki;


Replace “wiki” in the above with your own database’s name.


UPDATE user SET user_password = MD5(CONCAT(user_id, ‘-‘, MD5(‘newpasswordgoeshere’))) WHERE user_name = ‘usernameofuser’;


If this is successful you should get the following:


Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0


If something has gone wrong (e.g. a non-existent username) you will get the following instead:


Query OK, 0 rows affected (0.03 sec)
Rows matched: 0  Changed: 0  Warnings: 0


All done! To leave mysql just type “exit”.