Setup a Project Wiki: Difference between revisions
Jump to navigation
Jump to search
Jjaythomas (talk | contribs) |
Jjaythomas (talk | contribs) |
||
| Line 107: | Line 107: | ||
upload_max_filesize "25M" | upload_max_filesize "25M" | ||
==Reset Passwords on | ==Reset Passwords on MediaWiki== | ||
'''Determine 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: | 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; | <font color=red>mysql</font><font color=blue>></font> '''use wiki_databasename; SELECT * FROM user;''' | ||
Determine ID: | '''Determine ID:''' | ||
To find out the user_id of a particular user (necessary to generate hash): | To find out the user_id of a particular user (necessary to generate hash): | ||
SELECT user_id, user_name from user WHERE user_name=" | <font color=red>mysql</font><font color=blue>></font> '''SELECT user_id, user_name from user WHERE user_name="UserName";''' | ||
Reset Password: | |||
'''Reset Password:''' | |||
Command to reset User password in mySQL: | Command to reset User password in mySQL: | ||
UPDATE user SET user_password=md5(concat(<user_id>,'-',md5('newpassword'))) where user_name= | <font color=red>mysql</font><font color=blue>></font> '''UPDATE user SET user_password=md5(concat(<user_id>,'-',md5('newpassword'))) where user_name=; | ||
''' | |||