How To Change WordPress Password From phpMyAdmin Safely?
November 13th, 2014 | by Ravi Chahar || 36 Comments |
If you are thinking about changing the password in WordPress then you would love to know about this method. I have explained the simple method to change WordPress password and changing WordPress username earlier.
But it’s good to know another method. Here in this blog post, I am going to tell you how to change WordPress password from phpMyAdmin? Many of you are aware of using cPanel but if you are not then it’s you will find this post interesting.
Steps to change WordPress password using cPanel :
Sometimes you may not able to open your login page so at that time you can’t do anything other than changing the password of WordPress. At that time you can’t change password directly so you have to use phpMyAdmin. There are some simple steps you have to follow.
Step 1). First, you have to login into your cPanel provided by your hosting service. After logging in you have to go to your database section where you will find “phpMyAdmin“. Click and a new window will appear in front of you.
Step 2). After going to that new page you will see many options in which you need to click on “Databases” because you have to choose the database for which you are required to change password. After clicking at “Databases” you have to select your database.
Step 3). Again you will see that a list whose each option is followed by prefix “wp_” from which you have to select “wp_users“.
Step 4). After clicking at “wp_users” again a new page will open where you will options of “copy”, “edit”, delete” from which you have to select “edit” where you will see a symbol of a pencil.
Step 5). This is the final step where you will see many options using which you can change your WordPress username and password too. If you want to change WordPress password then you have to change the input of the box appearing in front of “user_pass“. You will see that WordPress has created its password consisting many symbols, numbers. The Password will be complex due to security reasons.
You will see that WordPress has created its password consisting many symbols, numbers. The Password will be complex due to security reasons. Fill the password you want.
But before that, you have to choose “MD5” as the function from the drop-down menu. It would convert your password into the form which is WordPress friendly.
It is recommended that you should also choose a strong password which is hard to break. After filling your new password you have to go downward and save settings.
Have you ever changed your password?
Have you ever changed your WordPress password? Did you know that you can change password of WordPress using phpMyAdmin? Do you know the simple method?
Are you going to change it for security? You may in need to change your password to increase the security of your website. I hope this tutorial is going to help you.