You have wordpress blog and for some reason you want to reset admin password of it. You can do so easily using your control panel cpanel. Your webhosting service provider will provide you cpanel as webhosting control panel using which you can easily manage all aspect of your hosting account. cPanel includes a very useful tool called phpMyAdmin which is used to mange your databases so if you want to reset password for your blog then most convenient way is through phpMyAdmin databases management tool.
You need to login to your control panel cPanel >> MySQL Databases section, scroll down and click on phpMyAdmin link or
Goto cPanel >> Databases>>phpMyAdmin
After you got in phpMySQL you have to select Wordpress dataases from the drop-down list, you will get all batabase tables, now open SQL tab and just fire following SQL query in it.
UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here’ ) WHERE `wp_users`.`user_login` = “admin_username”;
“new_password_here” - your new password goes here
“admin_username” – the username for which you are updating password shouls be used here.
Just click on GO button and you have updated/reset password for Admin/user for yoru WordPresss Blog. If everything goes fine you can login to your WordPrress blog using new password.
Posted under Linux cPanel Hosting, Shared cpanel Hosting, cPanel Hosting, cPanel hosting accounts
This post was written by on October 23, 2008
