Table of Contents
ToggleHow to change WordPress password from phpMyAdmin cPanel?
To change the WordPress password from the database (phpMyAdmin), first, you need to open your cPanel. Then in the Database section click on phpMyAdmin. Once you are in your database, look for your website from the tables. Once you click on the said table you will see a list. Look for {table-prefix}_users and right-click on it and click Browse.
WordPress Change Password PhpMyAdmin
You know just how important it is to have a secure WordPress password. To help protect your WordPress website from potential hackers, changing your WordPress password with PhpMyAdmin is an easy and secure way to keep your data safe. PhpMyAdmin is an open-source tool used to manage a database, which you’ll need in order to change your WordPress password. In this guide, we will explore how to quickly and securely change your WordPress password with PhpMyAdmin.
Understanding the PhpMyAdmin Tool
In order to change your WordPress password with PhpMyAdmin, it’s important to understand a few things about the tool. PhpMyAdmin is a free, open-source web-based application used to manage a MySQL database, which is the type of database WordPress relies on. This application is primarily used by web developers as a powerful tool to interact with their database. It provides users with the ability to edit, execute, and manipulate their MySQL database. In order to use PhpMyAdmin to change your WordPress password, you’ll need to obtain the root login credentials and know the database name associated with your WordPress site.
Step-by-step Guide to Changing Your WordPress Password with PhpMyAdmin
Now that you understand PhpMyAdmin, let’s go through the steps needed for changing your WordPress password with PhpMyAdmin.
The first step in this process is to access PhpMyAdmin. Depending on your hosting provider, you can access the database through the control panel of your website. You should then login with the root user account and password. Once logged in, you’ll be able to view a list of your databases. Note: It’s important that you know the database name associated with your WordPress website before proceeding.
Next, open the database associated with WordPress and select the ‘SQL’ tab. The MySQL code view of your database will open. From here, you’ll need to enter the following code into the text box:
UPDATE `wp_users` SET `user_pass` = MD5(‘yourpassword’) WHERE `wp_users`.`user_login` = ‘yourusername’;
From here, replace ‘yourpassword’ with the new password you wish to use and ‘yourusername’ with your user name. It’s important to note that the code must be entered exactly as shown in order for the new WordPress password change to take effect. Once you’ve entered the code, click the submit button. This will apply the new WordPress password and it will be successfully updated. Your WordPress password is now changed and you should no longer have access to the old one.
Conclusion
WordPress security should always be taken seriously, and changing your WordPress password with PhpMyAdmin is an easy and secure way to do just that. With this guide, you now know the steps needed to successfully change your WordPress password with PhpMyAdmin. However, since this method requires you to know the root credentials and database name associated with your WordPress website, it’s important to keep them secure and store them in a safe place. If remembering multiple passwords and credentials are becoming overwhelming, a password manager like is a great way to help you stay organized and secure. offers a free account for personal use and is an easy way to manage all your passwords and social accounts in one place.
FAQs
Are there other ways to change my WordPress password?
Yes, there are other ways to change your WordPress password. You can also reset your password directly from the login page or from your WordPress dashboard.
Are there any risks associated with changing my WordPress password with PhpMyAdmin?
Yes, it’s possible that you could make a mistake when entering the code to update your password, which could cause irreversible damage to your WordPress site. Additionally, it’s important that you keep your database credentials secure and stored safely.
What should I do if I forget my WordPress password?
If you forget your WordPress password, you can go directly to the login page and click the ‘Lost your password? You will then be asked to enter your email address and a reset password link will be sent to you.
WordPress is one of the most popular content management systems on the web, and often the first choice for many website developers. With its extensive features and support, WordPress is the go-to platform for many web development projects.
Unfortunately, like any online platform, it is important to keep your WordPress security up to date. This includes regularly changing your WordPress password. While this process can be done directly within the WordPress dashboard, there is an alternative method that allows you to change your WordPress password using phpMyAdmin.
For those unfamiliar with phpMyAdmin, it is a free, open-source tool used for managing MySQL and MariaDB databases. It is often used in conjunction with WordPress as it provides an easy way to manage your WordPress data. Additionally, it can also be used to access the database and make changes including altering the WordPress password.
Before attempting to change your WordPress password using phpMyAdmin, it is important to make sure that you have the latest version of phpMyAdmin installed. Additionally, you need to know the correct username and password to access the phpMyAdmin database.
Once logged in, navigate to the “Database” tab on the left pane of the phpMyAdmin window. Then click the “Browse” button next to the WordPress database you wish to update. This should display a list of WordPress tables in the lower section of the window.
Look for the “usr” table. Under this should be a list of the site’s current WordPress users. To change a user’s password, simply click the “Edit” icon next to the user’s username. This will open an additional window with the user’s profile details.
Now, enter the new password into the “password” field and confirm that it is correct. Then click “Go” at the bottom of the window to save the new settings. Your wordpress user’s password has now been successfully changed.
It is important to remember to frequently change your WordPress passwords as this will help to ensure the security of your WordPress website. While this process can be done directly within the WordPress dashboard, phpMyAdmin offers an alternative method for changing your WordPress passwords. Using this method, you can quickly and easily change your WordPress password whenever needed.

Mark, armed with a Bachelor’s degree in Computer Science, is a dynamic force in our digital marketing team. His profound understanding of technology, combined with his expertise in various facets of digital marketing, writing skills makes him a unique and valuable asset in the ever-evolving digital landscape.