|
|
| (10 intermediate revisions by 5 users not shown) |
| Line 1: |
Line 1: |
| − | {{procedure
| + | #redirect [[MediaWiki SQL queries#Reset a user password]] |
| − | |description = Use this process to set the password for a MediaWiki user.
| |
| − | |role = Sysop
| |
| − | |status = in use
| |
| − | }}
| |
| − | | |
| − | You need to log in to the database directly. Then obtain the user's id as in the following example (alternatively, go to [[Special:Userlist]] and get the id from there):
| |
| − | {{code|<mysql>
| |
| − | SELECT user_id FROM prefix_user WHERE user_name='user';
| |
| − | </mysql>
| |
| − | }}
| |
| − | Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222):
| |
| − | {code|<mysql>
| |
| − | UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;
| |
| − | </mysql>
| |
| − | }}
| |
