How to change your WordPress login Password using phpMyAdmin

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. 

  • phpmyadmin, wordpress login, Wordpress
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Debug WordPress Errors

WordPress debug mode and database query debug mode can be enabled in order to troubleshoot issues...

How to Install WordPress on domains using Softaculous

The below steps will guide you through installing WordPress on your domain within DirectAdmin....

How to increase or change max_input_vars on DirectAdmin

This guide will walk you through changing or increasing max_input_vars for a website hosted on...

How to change upload_max_filesize in DirectAdmin

This guide will walk you through changing or increasing upload_max_filesize for a website hosted...

How to install a Free Lets Encrypt SSL on your Domain with DirectAdmin

This guide will walk you through installing a free Lets Encrypt SSL on your domain within your...