This is very often people ask me about resetting their WordPress user password or username. In general you cannot change the username of WordPress username, but if you edit the database, you can do that. Well the process is easy, if you follow the following steps.
Login to your cPanel: To login to your cPanel enter http://yourdomain.com:2082 or http://yourdomain.com/cPanel. You’ll get a page like the picture below.
Search for phpmyadmin: to the top-left corner there’s a search box, type phpmyadmin there & you’ll find the phpmyadmin. You can also look through the page to find it. Now click on phpmyadmin.
Select the database you want to edit: From the left panel select the database you want to edit. If you have more than one database, and you’re confused about which database to edit, just go to File Manager from your cPanel and edit wp-config.php, there you’ll find the database name.
Select wp_users table: Now, when you select your database, you’ll see a list of tables in the left side bar. Select wp_users from the table.
Click Edit on the user you want to edit: Once you select wp_users, you’ll see a list of users in the right side, just click Edit on the user you want to edit.
Now it’s time to edit the username & password: Now you’ll see a list of fields there you’ll find user_login and user_pass. If you want to edit the Username only, just change the username. But if you need to change the password first select MD5 like the picture below, and now type the password you want to set for the user. Remember, you must select MD5, otherwise it’ll not work.
Now you’re all set, just click GO (you’ll find it below the form).
If you like the post, please share with your friends. And if you like my blog, you can join the fan page to get the latest updates. And obviously I suggest you to email subscribe through the form given at the top right corner to get the latest updates into your mail box, oh, I don’t spam.