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

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

How to Disable WordPress Pingback to Prevent Pingback Brute Force and DDoS Attacks?

WordPress has become the most popular CMS and it continuously increases its market share. On the...

How to Enable PHP Error Log for a WordPress website?

Wordpress is widely used open-source CMS and it is coded in PHP and MySQL. Wordpress provides a...

How to Deactivate All Plugins Without Accessing WP-Admin?

While troubleshooting any WordPress issues, you are asked to deactivate all plugins and activate...

How to Install WordPress Through Softaculous?

Once you get the Login details for your cPanel account, You can easily install the WordPress with...