

- #Reset mediawiki password how to#
- #Reset mediawiki password install#
- #Reset mediawiki password update#
- #Reset mediawiki password password#
$user->setEmailAuthenticationTimestamp( wfTimestampNow() ).The following content has been placed in a collapsed box for improved usability. Old instructions in case something goes wrong If you have difficulty using them on the terminal, you can instead use the user id prefixed with #. MediaWiki usernames can contain UTF-8 characters.

#Reset mediawiki password password#
#Reset mediawiki password update#
UPDATE user SET user_password=md5(concat(1,'-',md5('local'))) where user_id=1 Ĭhange ‘local’ to whatever you want the password to be, and adjust the user_id value as required. We can see that our user’s user_id has a value of 1. Click on the “Browse” tab, which takes us back to our first screenshot. Once you execute one of those three queries, you should see something like this:Īs you can see in the above screenshot, the binary version of our user’s name is 4b656e. SELECT user_name FROM user WHERE user_email = should be able to get their user name from the history of any page they’ve edited, or from their user page if they’ve created one. SELECT user_name FROM user WHERE user_real_name = 'Joe User' SELECT user_name FROM user WHERE user_name = 'username' Go to the SQL tab and enter one of the following commands: The second option requires that you know at least one of those actual values. If you only have a handful of users, this is not a bad way to go. Open it in a text editor and you’ll see its actual value. You have two options here:įirst, you can actually click on any of those values I just mentioned and download the. Note that MediaWiki stores both the user_name, user_real_name, and user_email as binary values, so you can’t actually tell which user you are looking at.
#Reset mediawiki password install#
This is from a localhost install that I created to test things out, so it only has one user. Navigate to that table and you’ll see something like this: MediaWiki stores user information in a table called “user”.

If you don’t, consult your host’s knowledge base for instructions.)
#Reset mediawiki password how to#
(I’m going to assume that you know how to log in to your instance of phpMyAdmin. Fortunately, there’s an easy way using phpMyAdmin. But sometimes that doesn’t work (which was the case here-I need to update that install, which is why I was changing passwords), and sometimes you need to reset a password for a user, rather than yourself. MediaWiki does, like all other CMSs, have a “reset password” option. For some reason, my browser didn’t store the new one, and I hadn’t yet written it down. I recently locked myself out of my own wiki while changing passwords.
