If you’re like me and you forgot your wordpress password and don’t have email setup on your system there are alternative ways to set a new password rather then sending and email.
Pick a particular method depending on what type of access you have to your website/hosting.
The easiest ways is through the MySQL command line but you need ssh access to your server.
- Connect to MySQL:
# mysql -u root -p
- Select the wordpress database (replace DATABASE with the wordpress database, if you don’t know it you can find it in wp-config.php under DB_NAME):
mysql> use DATABASE;
- Update the password running the folowing query (replace NEWPASSWORD with your new password and USERNAME with the username you wish to change the password for):
mysql> UPDATE wp_users SET user_pass = MD5('NEWPASSWORD') WHERE user_login = 'USERNAME';
Through ftp/file edit
If you don’t have MySQL access you can also reset it by editing your theme’s functions.php file. Edit the file and insert after the first <?php the folowing(replace NEWPASSWORD with your new password):
After you changed your password make sure you delete the line from functions.php otherwise it will reset your password on every page load.