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 Change WordPress Theme from phpMyAdmin?

Wordpress theme defines the display of your website. Generally, we change the Wordpress theme...

How to fix too many redirects after updating Wordpress?

We will go through some troubleshooting steps for the following error which might appear after...

How to migrate wordpress posts from wordpress.com to Self-Hosted WordPress website?

At Wordpress.com, you can create your blogs and website easily. You don't need to worry for...

How to Enable Gzip Compression for WordPress via .htaccess file?

When Gzip compression isn't enabled on WordPress website, Google PageSpeed Insight gives you a...

How to fix Error establishing a database connection in WordPress?

An error establishing a database connection in WordPress is a worst nightmare for all WordPress...

  • 0 Users Found This Useful

Was this answer helpful?