wordpress: Changing wordpress password from phpMyadmin

What if you have forgot your password and to the distress your mail server is down to change it through email. Don't worry if you have access to the database of the site.

1. Go to your phpMyadmin interface
2. Run the following SQL with necessery modifications

 

UPDATE `wp_users` SET `user_pass` = MD5('newPassword') WHERE `wp_users`.`user_login` ="yourUserName" LIMIT 1;


Thats all! enjoy