• Skip to primary navigation
  • Skip to main content

joshsushi

  • About
  • Blog
    • Freelancing
    • Marketing
    • WordPress
    • Uncategorized
  • Tools
  • Contact

Change Your WordPress Username in PhpMyAdmin

Here’s how to change your WordPress username in PhpMyAdmin.

If you have access to the WordPress admin area, I recommend you use a search and replace plugin to change your username and email address.

However, if you are in the middle of a site migration or working on a staging site and unable to access the WordPress admin area, use the following MySQL command to replace the username.

1. Open your database in PhpMyAdmin.2. Click on the database name of your site to unfold the tables associated with it.

3. Click on wp_users. This is the table where the user information is stored.
4. Select the user you want to change the username for.

Look for the row user_login. The value in this field is the username of this user.

You can also change other values.
user_nicename → user nickname.
user_email → user email address.
display_name → user display name.

Press ‘Go’ to make the changes.

Do not type in and try to change your password here. If you want to change your password, first update your username and/or email address, then use the WordPress’s “lost your password?” function to update your login password.

Updated 2021-01-09 Post Under: Wordpress

Other Posts

  • Why SendFox? Best Entry-level Email Service Provider
  • Apply CSS to WordPress admin
  • Best Website Hosting for Beginners, Freelancers, and Agencies
  • How to Change the Font Inside Gutenberg Editor
  • SiteGround Hosting Limitations
  • Replace URL in the PhpMyAdmin Database Using MySQL Scripts
  • Get SSL with a Site on Hostinger for Free
  • Get Unstuck Writing Your Blog Post (My 5-Step Writing Process)
  • Optimize WordPress Images to Make Your Site Faster
  • How to Hire Freelance Composer, Arranger, Audio Engineer or Musician

Copyright © 2023 · joshsushi.com