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

That's it! You can now log in to your WordPress admin area using this new username.
  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to reset WordPress admin user's password?

There are several ways to reset WordPress admin user password in WordPress. A simple method is to...

How to Fix the 500-Internal Server Error in WordPress?

So you have been receiving 500 Internal Server Error in your WordPress website? Don’t panic, have...

How to fix an error SSL certificate problem, verify that the CA cert is OK?

You may encounter this error while performing actions like theme/plugins installation or...

How to Upload a WordPress theme?

Sometimes you are required to upload and install a WordPress theme manually, especially when you...

How To Fix An Error "SSL certificate problem: unable to get local issuer certificate"

This error can be encountered while upgrading WordPress or installing a WordPress plugin from the...