Follow the below steps to change your WordPress login password using phpMyAdmin.

absolutehosting.co.za DirectAdmin login

  • Click on MySQL Management.

absolutehosting.co.za - directadmin mysql management

  • Click on the Plus Icon to the right of your WordPress database. 
  • Click on Log in to phpMyAdmin.

absolutehosting.co.za - log into phpmysql1

  • Click on your WordPress database on the left.

absolutehosting.co.za - phpmyadmin home

  • Find the {table-prefix}_users table.
  • Click on the Browse button.

absolutehosting.co.za - _users browse

  • Click on the Edit button.

absolutehosting.co.za - _users edit1

  • Enter the new password for your WordPress user.
  • Set the user_pass function to MD5.
  • Click on the Go button to the bottom right.

absolutehosting.co.za - phpmyadmin change password

You have now changed your WordPress login password and can login to your WordPress /wp-admin section with the new details. 

Was this answer helpful? 3 Users Found This Useful (4 Votes)