https://aznot.com/index.php?action=history&feed=atom&title=MediaWiki%2FPassword 2026-05-06T00:24:45Z Revision history for this page on the wiki MediaWiki 1.41.0 https://aznot.com/index.php?title=MediaWiki/Password&diff=6680&oldid=prev 2023-12-31T06:52:06Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 06:52, 31 December 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Manually Reset Password ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Manually Reset Password ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>To reset password (will set to 'local'): &lt;ref&gt;https://techblog.kjodle.net/2018/05/28/change-a-mediawiki-password-via-phpmyadmin/&lt;/ref&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>To reset password (will set to 'local'): &lt;ref&gt;https://techblog.kjodle.net/2018/05/28/change-a-mediawiki-password-via-phpmyadmin/<ins style="font-weight: bold; text-decoration: none;">&lt;/ref&gt; &lt;ref&gt;https://www.mediawiki.org/wiki/Manual:Resetting_passwords</ins>&lt;/ref&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  UPDATE user SET user_password=md5(concat(1,&#039;-&#039;,md5(&#039;local&#039;))) where user_id=1;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  UPDATE user SET user_password=md5(concat(1,&#039;-&#039;,md5(&#039;local&#039;))) where user_id=1;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> UPDATE `user` SET user_password = CONCAT(':B:1234:', MD5(CONCAT('1234-', MD5('somepass')))) WHERE user_name = 'someuser';</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Note: MySQL salted (1234 is the salt. You can replace it with any number as long as both places the number is used are the same).  Manually set the "B" format. This format is very easy to set from an SQL query. It is not the default format as it is weaker than pbkdf2, however that's ok as the user_password field will be upgraded to the correct format the next time the user logs in.</ins></div></td></tr> </table>

Kenneth https://aznot.com/index.php?title=MediaWiki/Password&diff=6679&oldid=prev 2023-12-31T06:48:56Z

<p>Created page with &quot;== Manually Reset Password == To reset password (will set to &#039;local&#039;): &lt;ref&gt;https://techblog.kjodle.net/2018/05/28/change-a-mediawiki-password-via-phpmyadmin/&lt;/ref&gt; UPDATE user SET user_password=md5(concat(1,&#039;-&#039;,md5(&#039;local&#039;))) where user_id=1;&quot;</p> <p><b>New page</b></p><div>== Manually Reset Password ==<br /> <br /> To reset password (will set to &#039;local&#039;): &lt;ref&gt;https://techblog.kjodle.net/2018/05/28/change-a-mediawiki-password-via-phpmyadmin/&lt;/ref&gt;<br /> UPDATE user SET user_password=md5(concat(1,&#039;-&#039;,md5(&#039;local&#039;))) where user_id=1;</div>

Kenneth