How To Change Lost WordPress Admin Credentials

For this exercise, you will need access to the MySQL database that hosts your site database and run some basic commands provided below.

Where are these credentials stored?
WordPress user credentials are stored in the users’ table of the site database, the username is stored on the user_login column while the password is stored under the user_pass column.

Mysql commands to update credentials:
UPDATE wp_users SET user_pass = MD5( ‘New Password’ ) WHERE wp_users.user_login =”user”;

NB: WordPress tables use a prefix eg wp_users represents the users’ table.