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... |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
===How do I reset a password in MediaWiki?=== | ===How do I reset a password in MediaWiki?=== | ||
This is for the extreme case where you've lost your admin password. | |||
You'll need to use phpMyadmin or mysql at the command line to specify the following | You'll need to use phpMyadmin or mysql at the command line to specify the following | ||
| Line 6: | Line 8: | ||
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! | ||
Latest revision as of 13:30, 3 July 2008
How do I reset a password in MediaWiki?
This is for the extreme case where you've lost your admin password.
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!
