Setup a Project Wiki: Difference between revisions
Jump to navigation
Jump to search
Jjaythomas (talk | contribs) |
Jjaythomas (talk | contribs) |
||
Line 108: | Line 108: | ||
==Reset Passwords on mediaWiki== | ==Reset Passwords on mediaWiki== | ||
Isolate User Name: | |||
To find out all the users in a particular Wiki, to isolate the actual user name of person you want to change the password for: | |||
use wiki_databasename; SELECT * FROM user; | |||
Determine ID: | |||
To find out the user_id of a particular user (necessary to generate hash): | |||
SELECT user_id, user_name from user WHERE user_name="Diane"; | |||
Reset Password: | |||
Command to reset User password in mySQL: | |||
UPDATE user SET user_password=md5(concat(<user_id>,'-',md5('newpassword'))) where user_name=RealName; |