https://kb.pathosting.co.th/index.php?action=history&feed=atom&title=Smf_change_members_password_via_phpmyadmin 2026-05-07T13:22:42Z Revision history for this page on the wiki MediaWiki 1.39.7 https://kb.pathosting.co.th/index.php?title=Smf_change_members_password_via_phpmyadmin&diff=487&oldid=prev 2012-07-17T17:33:42Z

<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 00:33, 18 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5">Line 5:</td> <td colspan="2" class="diff-lineno">Line 5:</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>ให้แก้ตรง '''username''' เป็น memberName ของบัญชีที่ต้องการเปลี่ยนรหัสผ่าน</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>ให้แก้ตรง '''username''' เป็น memberName ของบัญชีที่ต้องการเปลี่ยนรหัสผ่าน</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 `smf_members` SET `passwd` = SHA1(CONCAT(`memberName`,'new-password')) WHERE `memberName`=''''username'''';</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 `smf_members` SET `passwd` = SHA1(CONCAT(`memberName`,'new-password')) WHERE `memberName`=''''username'''';</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;">== สำหรับเวอร์ชั่น 2.0.x ==</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 `smf_members` SET `passwd` = SHA1(CONCAT(`member_name`,'new-password')) WHERE `member_name`=''''username'''';</ins></div></td></tr> </table>

Admin https://kb.pathosting.co.th/index.php?title=Smf_change_members_password_via_phpmyadmin&diff=483&oldid=prev 2012-05-21T00:44:27Z

<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 07:44, 21 May 2012</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">Line 3:</td> <td colspan="2" class="diff-lineno">Line 3:</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>  passwd = SHA1( CONCAT(`memberName`, 'your-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>  passwd = SHA1( CONCAT(`memberName`, 'your-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;"><div>== SQL สำหรับเปลี่ยนรหัสผ่าน ==</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>== SQL สำหรับเปลี่ยนรหัสผ่าน ==</div></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>  UPDATE `smf_members` SET `passwd` = SHA1(CONCAT(`memberName`,'new-password')) WHERE `memberName`='username';</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><ins style="font-weight: bold; text-decoration: none;">ให้แก้ตรง '''username''' เป็น memberName ของบัญชีที่ต้องการเปลี่ยนรหัสผ่าน</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>  UPDATE `smf_members` SET `passwd` = SHA1(CONCAT(`memberName`,'new-password')) WHERE `memberName`=<ins style="font-weight: bold; text-decoration: none;">'''</ins>'username<ins style="font-weight: bold; text-decoration: none;">'''</ins>';</div></td></tr> </table>

Admin https://kb.pathosting.co.th/index.php?title=Smf_change_members_password_via_phpmyadmin&diff=419&oldid=prev 2011-05-22T16:27:12Z

<p>Created page with &quot;<a href="/Category:SMF" title="Category:SMF">Category:SMF</a><a href="/Category:Tips" title="Category:Tips">Category:Tips</a> SMF เข้ารหัส รหัสผ่าน ด้วย &#039;&#039;&#039;sha1&#039;&#039;&#039; ลักษณะนี้ passwd = SHA1( CONCAT(`memberName`, &#039;...&quot;</p> <p><b>New page</b></p><div>[[Category:SMF]][[Category:Tips]]<br /> SMF เข้ารหัส รหัสผ่าน ด้วย '''sha1''' ลักษณะนี้<br /> passwd = SHA1( CONCAT(`memberName`, 'your-password') )<br /> == SQL สำหรับเปลี่ยนรหัสผ่าน ==<br /> UPDATE `smf_members` SET `passwd` = SHA1(CONCAT(`memberName`,'new-password')) WHERE `memberName`='username';</div>

Admin