From 0481684ddc7d586cb7bda9d2cf2d16b642d485c9 Mon Sep 17 00:00:00 2001 From: Alexander W Dehnert Date: Sat, 13 Feb 2010 06:57:35 -0500 Subject: [PATCH] Import from TextPattern --- faq/68.mdwn | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 faq/68.mdwn diff --git a/faq/68.mdwn b/faq/68.mdwn new file mode 100644 index 0000000..38a500c --- /dev/null +++ b/faq/68.mdwn @@ -0,0 +1,23 @@ +[[!meta title="How do I reset my password for MediaWiki?"]] +The easiest way to avoid this problem is to set an e-mail address +in your account, so you can use the “Mail me a new password” +feature. However, if you find that you’ve forgotten the password to +an account on your wiki, and you don’t have an e-mail address set +for it, you can reset its password as follows: + +1. Log in to [phpMyAdmin](http://sql.mit.edu/phpMyAdmin/) with + your [SQL password.](/faq/59/) +2. From the menu on the left, select the database corresponding to + your wiki, and select the “user” table within it. +3. Click “Browse” at the top, and note down the user ID for the + account whose password you want to reset. (This will be 1 for the + first account.) +4. Click “SQL” at the top, and run the following command, + replacing “uid” with the user ID and “newpassword” with the new + password for the account: +5. - UPDATE user SET user\_password = MD5(CONCAT(user\_id, ‘-’, + MD5(’*newpassword*‘))) WHERE user\_id = *uid* + + + + -- 2.45.0