How to Change WordPress Admin Username through MySQL Database?

This article will provide you the step by step guidance on how to change the WordPress admin username through phpMyAdmin ..

 

  1. Login to the phpMyAdmin

  2. Double click on your WordPress database

  3. Double click on "wp_users" table

  4. Locate your user and click on "Edit"

    Browse your WordPress Database and Select wp_users Table

  5. Enter a new name in "user_login" fileld

    Enter a New Username in user_login Field

  6. Click on "Go" to save the changes

<pstyle="font-weight:400">That's it! You can now log in to your WordPress admin area using this new username.


Related Articles

How to enable/disable pingback and traceback in WordPress?

Pingback and tracebacks are link notifications which enable you to keep track when someone links...

Wordpress Login issue : Could not save password reset key to database.

For Wordpress admin account when you try to reset a lost password, You may get the error "Could...

How to change WordPress database table prefix?

If you have a wordpress website, you will see the default table prefix as 'wp_;'. However, some...

How to Migrate / Transfer WordPress Website from WordPress.com to AccuWeb Hosting?

If you have a basic plan at Wordpress.com, you can refer to the below steps and migrate the...

Fix-Your PHP installation appears to be missing the MySQL extension which is required by WordPress

Usually, this error does occur when you are using an incompatible PHP version with your current...

  • 0 Users Found This Useful

Was this answer helpful?