Change wordpress password in MySQL
Yes!! we can change password of worpress login directly on MySQL. Login to control panel and launch PHPMyAdmin.
- Go to SQL or MySQL section in your PHPMyAdmin.
- Now, enter the below given query:
UPDATE
`wp_users` SET `user_pass`= MD5('mypasswd') WHERE `user_login`='myuser';Note: table name is given is base table. Table prefix may change based on your configuration.
- Put your new password in mypasswd and change myuser as your WordPress username.
- Click “Go” or similar option at the bottom to execute the query.
- You will get one row affected message.