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.

About vtm

Well done is better than Well Said!!! Web Enthusiast, Blogger, Open source contributor!!! And Web/Software Consultant for Personal and Business

Leave a comment

Your email address will not be published. Required fields are marked *

2 × 1 =