If you have problems to access your Joomla 2.5 admin area and can not remember the correct password you can reset it directly from your database.
First, you should find which database your Joomla 2.5 installation uses. Detailed instructions are published in the following knowledge base article:
https://www.siteground.com/kb/How_to_find_database_details_of_my_Joomla_25_installation/
Then open your MySQL database management tool. The SiteGround clients can use phpMyAdmin available in their cPanel.
Load the tool and execute the following SQL query:
|
1
|
<span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">UPDATE</span> <span class="syntax_quote syntax_quote_backtick">`Your_Joomla_Database`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">Your_Joomla_Database_Prefix</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick"><strong>users</strong>`</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_quote syntax_quote_backtick">`password`</span> <span class="syntax_punct">=</span><span class="syntax_alpha syntax_alpha_functionName">MD5</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_quote syntax_quote_single">'New_Password'</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">WHERE</span> <span class="syntax_quote syntax_quote_backtick">`sgj_users`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`</span></span>
|
username
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">`</span> <span class="syntax_punct">=</span><span class="syntax_digit syntax_digit_integer">'Your_Joomla_Admin_Username'</span><span class="syntax_punct syntax_punct_queryend">;</span></span>
|
|
1
|
<span class="syntax"/>
|
|
1
|
|
In the above query change Your_Joomla_Database [/crayon]
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">with your actual Joomla database name.Set your database prefix instead of</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">Your_Joomla_Database_Prefix</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick"></span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">(forexample ifthe prefix is'jos_'the table stringwill be'jos_users')</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">.</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_backtick">Enter the newpassword andyour Joomla2.5admin username instead of the following strings:</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_single">New_Password</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_quote syntax_quote_single">and</span></span>
|
|
1
|
<span class="syntax"><span class="syntax_digit syntax_digit_integer">Your_Joomla_Admin_Username.</span></span>
|
Joomla is a powerful software that is easy to work with once you have the right host to support you. Before you lose any more time with the wrong host, check out the hostlantern Joomla hosting offer.
