Copahost Forum

[Mark]

One can use a simple MySQL query to change Joomla's admin username. The best way to manage database is through phpMyAdmin tool. All you need to do is login to your cPanel and click on phpMyAdmin in the database box. Alternatively, you can run the query directly for joomla's database if you are not using cPanel or don't have phpMyAdmin tool.

Select the Joomla database from the drop-down menu at left in phpMyAdmin. Database tables will be displayed on it and also the page will refresh. From the top navigation bar, open the SQL tab.

Write the following SQL query in the text field:-

Code: Select all

UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ;

"new_password" - replace this with the new password you wish to use.
"admin" - replace this if your admin username is different.
click on the GO button to submit the query, once you are ready. If everything goes fine without errors, you should be able to login to Joomla with the new password.

Note: These instructions are applicable both for Joomla 1.5 and Joomla 1.0.*.

If you have problems resetting the password yourself, you can ask us for assistance or simply post them here. eUKhost provides the best Joomla hosting and such requests are managed efficiently by our technical support team. You can check our joomla hosting plans at UK Shared Cpanel Hosting | PHP MySQL Linux Web Hosting