Reset password using MySQL

Step1: Login to MySQL console with command below

# sudo mysql -u root -p

Step2: Select the wordpress database

# use wordpressdb;

Step3: Find the Admin user

# SELECT ID, user_login FROM wp_users;

Step4: Reset password

# UPDATE wp_users SET user_pass = MD5(‘GiveStrongPasswordhere’) WHERE user_login = ‘Admin’;

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!