For most CMS you can just go to the login page and just request a new password or do it through the dashboard. This is a guide on doing it through the database in case you need to for anyone of these reasons:
- Only temporarily change the password and plan on changing it back.
- That option is disabled by a plugin.
- You do not have access to the email attached to the account
WordPress, Joomla, Zen Cart, and Magento
- Open your database using PHPMyAdmin.
- Go to the users table not the user_meta one.
- Locate the row with your desired account usually by the username or the email.
- Click edit on the row.
- - If you plan on changing the password back copy the string of characters from the password section and paste it into a notepad document so you don't lose it.
- Put in your desired password replacing the existing content.
- In the area right next to it there are different encryption options. Select the MD5 one and click go.
- The password should not be an encrypted string of characters.
- Now the password is changed. If you need to put the old password back you can replace the new one with the old one you saved just make sure not to encrypt the password as it is already encrypted.
There are different steps for each different version of drupal but most follow the same steps at the beginning.
- Open PHPMyAdmin and login.
- Click on your database and go to the users table.
- Under user the select the user and edit it.
- Copy the current password hash (encrypted password) out of the "Value" field.
- Enter the temporary/new password inot the "Value" field.
- -Drupal v6
- -Choose MD5 for encryption and hit go
- -Drupal v7
- -Do not use the MD5 encryption, instead you will just type in your password and run a specific php file that does the encryption for you.
- -Drupal v8
- -Reset password through yourdomain.com/user/password
- -The email must match a password on file.
- -Drupal v6