How to Change Wordpress Admin Password Using SQL Query

How to Change Wordpress Admin Password Using SQL Query

Have you forgotten Admin password of your Wordpress blog? With this simple SQL query you can easily reset your admin password.

Just pass the following SQL query either from Terminal or Web Based Database Manager (phpMyAdmin)

UPDATE wp_users SET user_pass = MD5( 'new-password' ) WHERE user_login = 'admin-username';

Change new-password with your new desired password and admin-username with your blog admin username for which you want to change password.

Leave a Reply