October 27

MediaWiki: How to reset my admin password?


In order to reset the password for MediaWiki’s admin, there are a couple of options:


1. The first and easiest one is to use the option ‘E-mail new password’ next to MediaWiki’s login. In this case the password will be sent to the email address assigned to the administrative user for the MediaWiki installation;


If this does not work for you, there is a another way to reset MediaWiki’s admin password.


2. Go to your cPanel > phpMyAdmin and select the MediaWiki database from the menu on the left. The page will refresh and the database tables will be displayed on it. Open the SQL tab (located at the top navigation bar).

In the text field write the following SQL query:


UPDATE user SET user_password = MD5( CONCAT( user_id, ‘-‘, MD5( ‘NEWPASS‘ ) ) ) WHERE user_id =1


Then click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to MediaWiki with the new password.


Copyright 2021. All rights reserved.

Posted October 27, 2011 by Timothy Conrad in category "Websites

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B