1 [[!meta title="How do I reset my password for MediaWiki?"]]
2 The easiest way to avoid this problem is to set an e-mail address
3 in your account, so you can use the “Mail me a new password”
4 feature. However, if you find that you’ve forgotten the password to
5 an account on your wiki, and you don’t have an e-mail address set
6 for it, you can reset its password as follows:
8 1. Log in to [phpMyAdmin](http://sql.mit.edu/phpMyAdmin/) with
9 your [SQL password.](/faq/59/)
10 2. From the menu on the left, select the database corresponding to
11 your wiki, and select the “user” table within it.
12 3. Click “Browse” at the top, and note down the user ID for the
13 account whose password you want to reset. (This will be 1 for the
15 4. Click “SQL” at the top, and run the following command,
16 replacing “uid” with the user ID and “newpassword” with the new
17 password for the account:
18 5. - UPDATE user SET user\_password = MD5(CONCAT(user\_id, ‘-’,
19 MD5(’*newpassword*‘))) WHERE user\_id = *uid*