How to reset WordPress password via phpmyadmin

There are so many questions that come to us, about how to reset a WordPress password. Often this happens because the customer forgot the WordPress password. Therefore, we will show you how to change your WordPress password via phpmyadmin.

  1. Login to your cPanel - If you are a MikyHost.com customer, to log in to your cPanel, you can go through the Client Area. In the Client Area, select Service>My services, then select the service product that you have purchased. Then scroll down, in the shortcut section, you can choose one of the cPanel menus. To go to the front page of cPanel, you can select the Home icon or the homepage.
    Select phpmyadmin.
  2. Select phpmyadmin
  3. Then click the name of your WordPress database in the left pane and click the prefix_users table as shown in the following image:
  4. Next on the new page, click on the pencil icon on the same line as the username you want to reset the password for.
  5. After entering the new page, you can change the password according to the data you want. Note that for the password field, you must select Function MD5 for the user_pass field:
  6. After that click the "GO" button at the bottom right of the screen. The next step you can try to login to the WordPress administrator page using the new password.

Good luck.

Was this answer helpful?

Related Articles

What is Softaculous Installer in cPanel?

If you have been struggling with the world of websites and web hosting for a long time, surely...

What is the difference between Cpanel and Client Area

There is a significant difference between cPanel and Client Area. To avoid misunderstandings, we...

How to make a Full Backup in Cpanel

Before you do a full backup on your hosting account, make sure the hosting disk space is...

How to change cPanel language to Indonesian

Maybe you are getting bored with English in your cPanel and you want to replace it with...

How to Redirect Domain via cPanel

Here's how to redirect a domain to another website via cPanel that you can try. 1. Login to...