How to change wordpress administrator password from SQL database

If you forget your password you can use the Forgot Password feature in which your new password will be mailed into your inbox. However if your website gets hacked by hackers in such situation it can can be handled by changing the password from SQL
If you are a non programmer even though you can’t go wrong with this process as it is too simple but make sure that you don’t change anything other than mentioned below.

• Open hosting account
• Select PhpMyAdmin from your hosting.

• Now Select your WordPress database(DB) from the drop down menu in Left Sidebar.
• After selecting the database the page will automatically reload and your tables will be visible.
• Look at the top navigation bar & click on the SQL tab
• In Text area type the following codes

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

Now you will replace new_password_here with your new password you want to set and admin_username with new administrator username.

• Now click Go Button and your Username and password will be changed.

Now you can login into your wordpress account with new password & username