KB wiki-1: Difference between revisions
From SWCP Support Wiki
Jump to navigationJump to search
New page: ===How do I reset a password in MediaWiki?=== You'll need to use phpMyadmin or mysql at the command line to specify the following command: UPDATE user SET user_password = md5(CONCAT... |
|||
| Line 6: | Line 6: | ||
UPDATE user SET user_password = | UPDATE user SET user_password = | ||
md5(CONCAT('123-',md5('newpassword'))) WHERE user_id=123; | md5(CONCAT('123-',md5('newpassword'))) WHERE user_id=123; | ||
Where 123 is the user_id of the person you need to reset. The salt (first part of | Where 123 is the user_id of the person you need to reset. The salt (first part of | ||
the CONCAT command) is the user_id followed by a dash. This is important! | the CONCAT command) is the user_id followed by a dash. This is important! | ||
Revision as of 17:58, 4 June 2008
How do I reset a password in MediaWiki?
You'll need to use phpMyadmin or mysql at the command line to specify the following command:
UPDATE user SET user_password =
md5(CONCAT('123-',md5('newpassword'))) WHERE user_id=123;
Where 123 is the user_id of the person you need to reset. The salt (first part of
the CONCAT command) is the user_id followed by a dash. This is important!
