How to reset WordPress password using PHPMyAdmin | RunCloud

Introduction

Forgetting a password can be a frustrating and time-consuming experience, especially when it comes to your WordPress site. Most prefer the email option but sometimes it may not work especially when you haven't configured transactional email on your server. However, there's no need to panic, as resetting your WordPress password is a simple process that can be done quickly and easily through PHPMyAdmin. In this blog post, we'll be going over the steps on how to reset your WordPress password using PHPMyAdmin on RunCloud.

Step 1: Log in to your RunCloud account and install PHPMyAdmin
Step 2: Access PHPMyAdmin
Step 3: Select the database associated with your WordPress installation
Step 4: Open the wp_users table
Step 5: Edit the user's password
Step 6: Log in to your WordPress site

Step 1: Log in to your RunCloud account and install PHPMyAdmin

To begin, you'll need to log in to your RunCloud account and install PHPMyAdmin on your server(if it's already installed you can skip this step). Kindly note, you just need a single PHPMyAdmin for entire server.

To install PHPMyAdmin, click on "Deploy New Web App" button. This will open up web application option, just select PHPMyAdmin from 'One-Click' option. Just name the web application and use domain name of your choice or just use their test domain itself. You can keep the rest of the default configurations itself.

Step 2: Access PHPMyAdmin

Once you've selected the appropriate server, Load the PHPMyAdmin by loading previously created domain name. We need to login to PHPMyAdmin to access the database details so please go to your WordPress web application and select file manager option. Here, you can see wp-config.php listed, please open that file. You will find your database and database user details there. For example, refer following example.

For login, we just need the 'DB_USER' and 'DB_PASSWORD' value to login to PHPMyAdmin.

Step 3: Select the database associated with your WordPress installation

Once inside the PHPMyAdmin, select the database that is associated with your WordPress installation. You can click on '+' symbol to see full database and click on your database name in left side to show further details.

Step 4: Open the wp_users table

Click on the "wp_users" table to open it. This table contains all of the users for your WordPress site. If you can't find the table, just seach the word "wp_users".

Step 5: Edit the user's password

Find the row that corresponds to the user whose password you want to reset and click on the "Edit" button. In the "user_pass" field, enter a new password. Make sure to change the "Function" field to "MD5" and then click on the "Go" button to save the changes.

Step 6: Log in to your WordPress site

Now that you've reset your password, you can log in to your WordPress site using the new password.

Conclusion

Resetting your WordPress password using PHPMyAdmin on RunCloud is a simple and straightforward process that can be completed in just a few minutes. By following the steps outlined in this blog post, you'll be able to reset your password and regain access to your WordPress site quickly and easily.

Please note that it's recommended to use the latest hash algorithm to encrypt your password instead of MD5 for better security. Also, make sure to keep your RunCloud and PHPMyAdmin credentials secure and keep a backup of your data.