Losing access to your WordPress site can be stressful, especially if it’s because of a hack. But don’t stress—there’s a solution!
This guide will show you how to reset your WordPress user password using phpMyAdmin.
Warning: You will be directly editing your database. If you aren't comfortable with this, we strongly recommend contacting your developer for assistance.
Finding the database name
Before we can edit the database, we will first need to find out which database we need to modify. If you have installed the Wordpress application on a singular domain, then you can skip this step. In this case, a single database will show under your website.
Enter your database
Login to the Cloud panel
Select the desired website
Go to Databases in the horizontal menu
Click on the corresponding database to the website
Select the single-sign on button "phpMyAdmin"
Changing a password in phpMyAdmin
On the left hand side you will see a list of databases, select your database to open a list of tables. Mostly it contains a "wp1" tag if left on default installation.
2. A list will open with different tables. Search and click the wp_users table. If you have entered a different prefix for your database, then "wp" can have another name. However, it will always end with _user
3. You will now see a list of WordPress users. Find the email address relating to the user you wish to update the password for and click "Edit"
4. Next, find the "user_pass" section and enter your new password in the box in plain text. Under "function", make sure you select MD5 from the dropdown selector menu.
5. Once all changes have been made. You can go ahead and click the "Go" option at the bottom of the page. This will save your new password.
Done! - You’ve successfully updated your WordPress password, and you should now be able to log in to your WordPress dashboard as usual.