blog standard

• Blog
• 23 December 2016

Change wordpress password in MySQL

Change wordpress password in MySQL

Yes!! we can change password of worpress login directly on MySQL. Login to control panel and launch PHPMyAdmin.

1. Go to SQL or MySQL section in your PHPMyAdmin.
   
2. 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.

3. Put your new password in mypasswd and change myuser as your WordPress username.
4. Click “Go” or similar option at the bottom to execute the query.
5. You will get one row affected message.