Change Your WordPress Admin Password From SQL Database.

Infrequently you will look such a condition when you will need to conversion your word press password from SQL database because if you ever forget your password you can use the Forgot Password mouth using which your new password will be mailed into your inbox. However if your website gets hacked or due to any reason you lose access to both your email and word press than such a condition can be touched by changing the password from SQL.

You are a non-programmer even then you can’t go wrong with this method as it is too modest but make sure that you don’t change anything other than stated in the steps below.

Open Hosting Account.
Select PHP  My Admin from your hosting. In Screenshot Below I have Shown PHP My Admin in C panel Hosting  

Select your Word Press database from the drop down menu in Left Sidebar. After  select the appropriate database the page will automatically reload and your tables will be visible.

Look at the top navigation bar and click on the SQL tab.

In the Text area type the following code

 

UPDATE `wp_users` SET `user_pass` = MD5( "new_password_here" ) WHERE `wp_users`.`user_login` = "admin_username";

Here you will replace new password here  with your new password you want to set and admin_username with new administrator username.

  

Now click on the Go Button and your Username and password will get changed.

 Login into   your word   press account with new username and  password. This method works on self-hosted word press.