{"id":251,"date":"2009-10-11T15:17:11","date_gmt":"2009-10-11T14:17:11","guid":{"rendered":"http:\/\/mccltd.net\/blog\/?p=251"},"modified":"2009-11-09T12:17:06","modified_gmt":"2009-11-09T12:17:06","slug":"joomla-recreating-super-user-if-you-delete-admin-account","status":"publish","type":"post","link":"http:\/\/darenmatthews.com\/blog\/?p=251","title":{"rendered":"Joomla &#8211; Recreating Super User if you delete admin account"},"content":{"rendered":"<h3><span class=\"mw-headline\">Add a new Super Administrator User<\/span><\/h3>\n<p>If changing the password won&#8217;t work, or you aren&#8217;t sure which user is a member of the Super Administrator group, you can use this method to create a new user.<!--more--><\/p>\n<ol>\n<li>Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.<\/li>\n<li>Press the &#8220;SQL&#8221; button in the toolbar to run a SQL query on the selected database. This will display a field called &#8220;Run SQL query\/queries on database &lt;your database&gt;&#8221;.<\/li>\n<li>Delete any text in this field and paste in the following text (click link to show text):<\/li>\n<\/ol>\n<p><a href=\"http:\/\/darenmatthews.com\/blog\/wp-content\/uploads\/2009\/10\/recover-joomla-admin-account.txt\">recover-joomla-admin-account<\/a><\/p>\n<dl>\n<dd>4. At this point, you should be able to log into the back end of Joomla! with the username of &#8220;admin2&#8221; and password of &#8220;secret&#8221;. After logging in, go to the User Manager and change the password to a secure value and the e-mail to a valid e-mail address. If there is a chance you have been &#8220;hacked&#8221;, be sure to check that all users are legitimate, especially any members of the Super Administrator group.<\/dd>\n<\/dl>\n<p>The examples above change the password to &#8220;secret&#8221;. Two other possible values are shown below:<\/p>\n<pre>- password = \"this is the MD5 and salted hashed password\"\r\n------------------------------------------------------\r\n- admin  = 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT\r\n- secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199\r\n- OU812  = 5e3128b27a2c1f8eb53689f511c4ca9e:J584KAEv9d8VKwRGhb8ve7GdKoG7isMm<\/pre>\n<p><!--  NewPP limit report Preprocessor node count: 13\/1000000 Post-expand include size: 0\/2097152 bytes Template argument size: 0\/2097152 bytes Expensive parser function count: 0\/100 --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Add a new Super Administrator User If changing the password won&#8217;t work, or you aren&#8217;t sure which user is a member of the Super Administrator group, you can use this method to create a new user.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15],"tags":[],"_links":{"self":[{"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/251"}],"collection":[{"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=251"}],"version-history":[{"count":9,"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/251\/revisions"}],"predecessor-version":[{"id":261,"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/251\/revisions\/261"}],"wp:attachment":[{"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/darenmatthews.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}