Difference between revisions of "Add a wiki database"
From Organic Design wiki
(status = in use) |
(oops wasn't mpved from tmp) |
||
Line 1: | Line 1: | ||
{{procedure | {{procedure | ||
− | |description = | + | |description = Use this process to set the password for a MediaWiki user. |
|role = Sysop | |role = Sysop | ||
|status = in use | |status = in use | ||
}} | }} | ||
− | + | You need to log in to the database directly. Then obtain the user's id as in the following example: | |
− | + | <pre> | |
− | '' | + | SELECT user_id FROM prefix_user WHERE user_name='user'; |
− | + | </pre> | |
+ | Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222): | ||
<pre> | <pre> | ||
− | + | UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222; | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</pre> | </pre> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 20:03, 21 November 2008
Add a wiki database Organic Design procedure |
You need to log in to the database directly. Then obtain the user's id as in the following example:
SELECT user_id FROM prefix_user WHERE user_name='user';
Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222):
UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;