How to Change WordPress Admin Username through MySQL Database?

This article will show you the basic steps on how to change the WordPress admin username through phpMyAdmin if you either forget your login credentials or wish to update the existing username to a more secure option. 

You can easily change the username by following the steps listed below – 

  1. Log in to the phpMyAdmin
  2. Double click on your WordPress database
  3. Then double click on the wp_users tabl
  4. Locate your user and click on Edit

Browse your WordPress Database and Select wp_users Table

5. Enter a new name in the user_login field

Enter a New Username in user_login Field

6. Click on Go to save the changes.


And that's it! 

You can now log into your WordPress admin panel using this new username.

Was this answer helpful?

« Back