Difference between revisions of "Reset a wiki user password"

Latest revision as of 11:05, 22 July 2019

Redirect to:

@@ 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):
-<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>
-    UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;
-</pre>