How to reset Joomla administrator password

July 4, 2010 · Filed Under Scripts · Comment 

Joomla’s administrator password can be changed with a simple MySQL query. Go to your cPanel and click on phpMyAdmin in the Databases box or access your MySQL database using the interface provided by your web hosting company.

We will consider that you have phpMyAdmin to manage your MySQL databases. In phpMyAdmin, select your Joomla database from the drop-down menu at left. The page will refresh and the database’s tables will be displayed at right side. Open the SQL tab (from the top navigation bar).

In the text field write the following SQL query:

UPDATE `jos_users` SET `password` = MD5( ‘new_password’ ) WHERE `jos_users`.`username` = “administrator” ;

“new_password” – replace this with the password you wish to set.
“administrator” – replace this if your admin username is different.

Once you are ready, click on the “GO” button to submit the query. If everything goes well, you should be able to login to Joomla with the new password.

These instructions are valid both for Joomla 1.0.* and Joomla 1.5.

If you have any questions related to Joomla, just ask your questions in our webmaster forum.

How to reset vBulletin administrator password

July 4, 2010 · Filed Under Scripts · Comment 

The following guideline will help you to reset your vBulletin administrator in an event when “Forgot password” doesn’t work for you:

[1] Browse your forum and log out (if you have logged in using other user) if you aren’t already. Register as a new user and login as this user.

[2] In the vBulletin’s .zip file you can find a directory called ‘do_not_upload/‘. Inside this directory, there is a file called ‘tools.php‘. Upload this file into your forum’s admincp/ directory. Then go to the admincp/tools.php with your browser.

[3] At the bottom of the tools page is an option to ‘Reset Admin Access‘. Run it with the just newly registered username.

[4] You have just made yourself admin and you need this because you should now login to the admincp/ and find the user who’s password you have lost. Search for this user and when found you will see the whole profile including a password field. Set a new password.

[6] Go to the main forum and log out from the new user, and try to login with the old admin account. This should work now.

[7] When it works, go back into the admin control panel and find the newly registered user. The profile page will have a drop down in the top, from there select delete and delete the temporary admin.

[8] Then delete the tools.php file from your web hosting account. It is a potential security risk if you leave it on the web site.

The above steps will help you to reset admin password for vBlletin 3.x version.

If you have any questions related to vBulletin, just ask your questions in our webmaster forum.

Untitled Document