WordPress username and password can be changed by logging in to WordPress Dashboard and then by going to “Users” section. From there you can edit any user account but for doing this, you must be having an admin user role. But what if you’re not able to login to the Dashboard? There is an easy way to change WordPress username and password from phpMyAdmin. By following this method, you can edit or change any user login credentials.
This method is very useful if your WordPress site is hacked and someone has changed your login credentials. In such a case, you won’t be able to login and therefore we’ll need to do this by logging on to cPanel (also called control panel).
How to Change WordPress Username and Password from phpMyAdmin
Follow this method, step-by-step:
- Login to your cPanel. The URL would be something like http://yoursite.com/cpanel.
- Find and click on phpMyAdmin.
- This should open phpMyAdmin. From the left hand side, click on your WordPress database name. If you have more than one WordPress installations, then you’ll need to click on the correct database name for which you want to change the username and password.
- Find wp_users table and then click on the “Browse” button.
- Now you’ll be presented with a list of different users. Click on the “edit” button corresponding to the user for which you want to change username and password.
- Change username: Locate the user_login ID. This is the username which is used to login. Edit the “value” field and change the username.
- Change password: To change password, locate the user_pass ID. From the “functions” drop down menu, select MD5. In the “value” field, delete old password and enter the new password as per your wish.
If you’re not comfortable following this method, then you can also seek the help of your web host. Their support staff can point you in the right direction.
Follow this method step by step and you’ll be able to change or edit any WordPress username and password, with the help of phpMyAdmin.