{"id":8,"date":"2006-06-26T11:17:13","date_gmt":"2006-06-26T11:17:13","guid":{"rendered":"http:\/\/ramblingsofasysadmin.com\/blog\/?p=8"},"modified":"2006-06-26T11:17:13","modified_gmt":"2006-06-26T11:17:13","slug":"how-to-reset-passwords-using-phpbb","status":"publish","type":"post","link":"https:\/\/ramblingsofasysadmin.com\/?p=8","title":{"rendered":"how to reset passwords using phpbb."},"content":{"rendered":"<p>while we don&#8217;t like using open source software (i suppose movabletype is possibly one of the few exceptions), there are always folks who love using phpbb &#8212; and then there are folks who love exploiting it.<br \/>\ni decided today that it would be a good idea to disable one of our inactive boards that was getting a lot of hits from spam bots &#8212; except that i couldn&#8217;t find the login information anywhere.<br \/>\nfortunately, i found out how to reset the password with this nifty little trick that requires, at the mininum, <a href=\"http:\/\/www.phpmyadmin.net\" target=\"_new\">phpMyAdmin<\/a> (so much for what i say about open-source software).<br \/>\nhere&#8217;s how it&#8217;s done:<br \/>\n1. ftp or log onto the server and navigate to your phpBB directory.  download or jot down the values in config.php.  (you can bypass this step if you use plesk.)<br \/>\n2. log onto your phpMyAdmin with the username and password that you have written down in step 1.<br \/>\n3. on the left hand navigational bar, click on the <b>phpbb_users<\/b> table &#8212; this is where your username and passwords are stored.<br \/>\n4. click <b>Browse<\/b> on the top of your screen to view a list of registered users.<br \/>\n5. search for the account that needs its password reset (e.g. Administrator)<br \/>\n6. click <b>Edit<\/b> (the little pencil icon works too)<br \/>\n7. from the <b>user_password<\/b> row, click the <b>Function<\/b> pull-down menu and choose MD5 (your password is stored in an MD5 hash)<br \/>\n8. in the empty box to the right of MD5, replace the password with your new password in plaintext<br \/>\n9. click <b>Go<\/b> at the bottom of the page.<br \/>\n10. that&#8217;s it!  now log in with the new password.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>while we don&#8217;t like using open source software (i suppose movabletype is possibly one of the few exceptions), there are always folks who love using phpbb &#8212; and then there are folks who love exploiting it. i decided today that it would be a good idea to disable one of our inactive boards that was getting a lot of hits from spam bots &#8212; except that i couldn&#8217;t find the login information anywhere. fortunately, i <span class=\"ellipsis\">&hellip;<\/span> <span class=\"more-link-wrap\"><a href=\"https:\/\/ramblingsofasysadmin.com\/?p=8\" class=\"more-link\"><span>Read More &rarr;<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8"}],"version-history":[{"count":0,"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=\/wp\/v2\/posts\/8\/revisions"}],"wp:attachment":[{"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ramblingsofasysadmin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}