MySQL command to reset(change) Joomla admin(administrator) password.

If you are here just to copy and paste the command for Joomla password reset, please scroll a little bit.

If you re not so experienced user landed here you may consider changing your Joomla’ password using PHP MyAdmin.
For those who are fine with SSH and MySQL commands you can continue with this tutorial.

If the case is that you are not so literal with SSH, MySQL, the command line at all, and you do not have installed or option to install PHP MyAdmin, you may find this tutorial: Access your server via SSH with Putty – useful.

First connect your MySQL database server. Usually this can be done trough the command line with this:

Now you can execute the following MySQL command to change Joomla admin password:

Change the string ‘anynewpassword’ with the new Joomla password, also if your administrator account was created with different user, do not forget to change ‘admin’ as well.

There is no need to do anything else like flushing database for example, but directly you may try your Joomla’s login with the new password.

For those who read my tutorial to the end I will provide a nice hint.
Lets say that you need the Joomla password changed just for a while – the owner of the site forget to provide it to you, or the person that is working on this project is not reachable.

Then list all the Joomla users with this MySQL command

This will pull up a listing with users and passwords. Just locate the ‘admin’ username and copy the password which probably looks something like this: 1Adsjkalheut67843sad
Keep that password in a text file and when you finish your work you can update the ‘admin’ again, but using the MySQL line like this:

Hope you got it. Thank you for reading this Joomla password reset tutorial. Cheers!

Tags

• joomla change user password command line
• changing a joomla password in command
• how to reset joomla admin password in command line
• command to change joomla admin password
• jos_users
• joomla administrator password reset command
• how to reset joomla admin password command
• joomla2 sshd
• joomla change password from comand line
• joomla change mysql password windows 7
• MD5 admin password jos_users
• mysql command for uddate jos_user password
• mysql command line joomla
• mysql command to search password joomla
• UPDATE `jos_users` SET `password` = MD5( ‘new_password‘ ) WHERE `jos_users` `username` = admin ;
• update `jos_users` set `password` = md5( ‘new_password‘ ) where `jos_users` `username` = admin
• ssh reset pass command
• reset skype password by username joomla
• reset password joomla administrator ssh
• reset joomla admin password from cmd