To know how to change your WordPress login Username and password from phpMyAdmin is one of the most important things to the WordPress User .Everyone should learn it how to change or reset WordPress user Name and password .
Because sometime may your site is hacked or something else then you are not able to login to your admin panel by using the previous Username and password and you are also not able to change your User Name and password via email.
We know that every WordPress blog uses a MYSQL Database that can be accessed through phpMyAdmin even if you are not using c Panel.
If you want to reset you WordPress Login User Name and password then follow Following Steps:
Here are the Steps to
Step 1- First Identify the Name of your Database:
It is always good work to know the name of your Own WordPress Database. Because if you run multiple installations within the same database, then you will need to find exactly where you have to reset user name and password. The best place to search your database with user name and password is wp-config.php file which is located in your root WordPress directory.
Step 2- Locating Database and Editing User Name and Password Fields
Go to your cPanel or other admin panel by using cPanel user Name and password.
Then you can access your MySQL database then click on phpMyadmin.
After going to phpMyAdmin you have to select the correct database on the left site of that page. Select that database name that you was found in your wp-config.php file then click on that and you will see a list of tables contains a prefix wp_ for the most part.
If you find the table named wp_user then click on it and then click on the Browse tab.
Click on the pencil Icon (Edit) to reset or change your wp -login User name and password.
Now you can see the following Fields and you have to change here.
Edit or reset the User_login filed by putting a value For example : hkabir and
Edit or change the User_pass field by putting a value For example: hkabircse093021
You will notice that in previous there are a lot of random characters in the password filed.For the reasons of security, WordPress Stores the password value as MD5 format rather than plain text.
That means you will not able to enter a plain text as the password .That is you have to convert it MD format and for this reasons you have to select MD5 from a combo box list of that line.Like below..
Then press go button for save changes.
Finally you have successfully changed your WordPress password and username from phpMyAdmin.
Incoming search terms are below:
Reset Password and UserName, Reset Password and UserName of WordPress with phpMyadmin,How do You Reset Password and UserName of WordPress with phpMyadmin,how to change your WordPress login Username and password from phpMyAdmin, how do i change wordpress password,how do i reset password,change wordpress password,how to reset password,how do you reset a password,login cpanel,