Learn how to change your WordPress password using phpMyAdmin

Forgot your WordPress password and are looking for a way to change it? The good news is that even if you don’t have access to the email account you want, you can easily recover your WordPress password using phpMyAdmin. In this article, join us to learn the steps to change your WordPress password and recover it using the WordPress and phpMyAdmin login pages.

Recover your WordPress password using phpMyAdmin

When you forget your WordPress password, the easiest thing to do is go to the same WordPress login page and click “Lost your password?”.

Password recovery for WordPress site

Forget and reset your WordPress password

By selecting this option, all you have to do is enter your username or email to be sent an email to recover your WordPress password. In the meantime, the problem is that sometimes we may not have access to the email we already entered for the account, or WordPress may not be able to send you this reset email for some reason. In this case, what is the solution? Yes, we go to the database; This is phpMyAdmin.

Steps to change your WordPress password using phpMyAdmin

If for some reason you can’t use the simple method above, go to the cPanel dashboard on your website and follow the steps below. It is worth mentioning that changing or recovering a WordPress password is also possible through the Direct Admin panel. The space and name of the direct administrator options are slightly different from cPanel; But the overall work in the two panels is similar.

Step 1: Log in to phpMyAdmin

After logging in to cPanel, find the “phpMyAdmin” option in the “DATABASES” section and click on it.

Reset the WordPress password with phpmyadmin

This will open up the phpMyAdmin space for your website; Where you have already built the database on your website.

Change the password via phpmyadmin in WordPress

Phpmyadmin space to change the password for WordPress

Step 2: Find username information

Here are the tables related to the WordPress database. So look for a row in these tables called “wp_users”. Then click on the “Browse” option, which is the name of this row in the right column.

    Change the WordPress password from the control panel

Find and modify WordPress user information from the phpmyadmin C panel

Since we can choose or change the prefixes of the names of these rows ourselves, of course the prefixes of these names in your table may be different. For example, you might have the name “ab_users” instead of “wp_users”.

Step 3: Change the password

You can now see the list of users who already have an account on the website. Find the name of your account in this list, and then click ‘Edit’ on the right side of this row.

Edit user information on WordPress

Change user information via phpmyadmin in WordPress

In doing so, you have a form that displays all of your user information and allows you to edit it.

Now, to change your WordPress password, simply delete the value in the “user_pass” row and in the “value” column and enter the new password of your choice. Then, in the “Function” column, select the “MD5” value and finally click the “Go” option at the bottom of the page.

WordPress password recovery

Set a new WordPress password

It is! Your password is encrypted using the MD5 hash and stored in the database.

Concluding remarks

Change the WordPress password using phpmyadmin; WordPress is a very user-friendly content management system that tries to make everything as easy as possible for users. However, sometimes we still have to go to the main resources of the website, ie. the server files or the database itself; Like changing and recovering a WordPress password, which can be done in minutes thanks to phpMyAdmin.

Frequently Asked Questions

1. How to change your password and username for WordPress?

If you have access to the email you entered for your account, just go to the regular WordPress login page and click the phrase “Lost your password?”. WordPress will send you an email containing your username to change your password.

2. Why should we use phpMyAdmin to change or reset a WordPress password?

We may not be able to use the WordPress login feature to reset your password for two reasons:

  1. We are unable to enter the email associated with the account we are considering.
  2. WordPress should not send us a reset email for any reason. In this case we need to proceed directly through phpMyAdmin.

3. Why use MD5 hash to change your WordPress password?

WordPress has been using the MD5 hash for years to encrypt passwords. Although newer algorithms have been added to WordPress since version 2.5, the MD5 hash can still be a good way to recover a WordPress password; Because it is compatible with both the old version of WordPress and the latest versions.

{“@context”: “https://schema.org”, “@type”: “FAQPage”, “mainEntity”: [{
“@type”: “Question”,
“name”: “چگونه رمزعبور و نام کاربری وردپرس خود را تغییر دهیم؟”,
“acceptedAnswer”: {
“@type”: “Answer”,
“text”: “اگر به ایمیلی که برای حساب کاربری خود وارد کرده‌اید، دسترسی دارید، کافی است وارد صفحه همیشگی لاگین وردپرس شوید و روی عبارت «آیا رمزعبورتان را گم کرده‌اید؟» کلیک کنید. وردپرس ایمیلی شامل نام کاربری را برای تغییر رمزعبورتان ارسال خواهد کرد.”
“@type”: “Question”,
“name”: “چرا باید از phpMyAdmin برای تغییر یا بازیابی رمزعبور وردپرس استفاده کنیم؟”,
“acceptedAnswer”: {
“@type”: “Answer”,
“text”: “به دو دلیل ممکن است نتوانیم از قابلیت خودِ صفحه لاگین وردپرس برای بازیابی رمزعبور استفاده کنیم:

نتوانیم وارد ایمیل مربوط به حساب کاربری مدنظرمان شویم.
وردپرس به هر دلیلی ایمیل بازنشانی را برایمان ارسال نکند. در این صورت، باید مستقیماً ازطریق phpMyAdmin اقدام کنیم.”
“@type”: “Question”,
“name”: “چرا از هَش MD5 برای تغییر رمزعبور وردپرس استفاده کنیم؟”,
“acceptedAnswer”: {
“@type”: “Answer”,
“text”: “سال‌هاست که وردپرس از هَش MD5 برای رمزگذاری رمزهای عبور استفاده می‌کند. هر‌چند از نسخه ۲٫۵ الگوریتم‌های جدیدتری برای این کار به وردپرس اضافه شد، هنوز‌هم هَش MD5 می‌تواند روش مناسبی برای بازیابی پسورد وردپرس باشد؛ چراکه هم با نسخه قدیمی وردپرس سازگار است و هم با جدیدترین نسخه‌های آن.”

A tutorial on changing the WordPress password via phpMyAdmin for the first time in Parsupak. appear.

Leave Your Comment

Your email address will not be published.

Supportscreen tag