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.


Related Articles

How To Fix An Error "The Uploaded file could not be moved to WP-Content/Uploads" folder?

Sometimes you receive following error while trying to upload new Media/Images to your WordsPress...

How to Increase maximum execution time for a WordPress Site?

You may receive the below error for your Wordpress while installing/updating themes or plugins....

How to Move WordPress From Root Directory to Subdirectory?

Sometimes you wish to install WordPress in root (wwwroot/public_html) directory, but you do want...

How to change your Wordpress website URL?

It is very easy to change your WordPress URL. You just need to put below code into the...

How to enable/disable pingback and traceback in WordPress?

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

  • 0 Users Found This Useful

Was this answer helpful?