Beginner's Guide for WordPress - Start your WordPress Blog in minutes.
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

How to Change your WordPress Username

Last updated on by
Elegant Themes
How to Change your WordPress Username

Have you ever tried to change your WordPress username just to find out that it cannot be changed? If you are, well then this article is for you. In this article, we will share a step by step guide on how to change the WordPress username on a cPanel Web Host using phpMyAdmin.

Note: To all users if this sounds scary, don’t worry. We will guide you step by step, so you don’t get lost.

Update: The easiest way to do this is create a new user account in WordPress (give it admin access). Then login with that username and delete your old account. If you are not sure how to add a new user in WordPress, then watch our free WordPress videos.

First thing you need to do is login to your cPanel. Scroll down to the databases section and click on phpMyAdmin.

phpMyAdmin from cPanel

Next you need to select the database that your blog is hosted in.

phpMyAdmin Select Database

Click on the table wp_users on the left hand side. Then click edit on the username that you want to edit.

Edit username from phpMyAdmin

Change the user_login value to whatever you want. For example you can replace ‘admin’ to ‘bob’

Change user_login value

Hit the Go button and you are done.

Go back to your site and login with your new username.


Editorial Staff at WPBeginner is a team of WordPress lovers led by Syed Balkhi. Page maintained by Syed Balkhi.

WPBeginner's Video Icon
Our HD-Quality tutorial videos for WordPress Beginners will teach you how to use WordPress to create and manage your own website in about an hour. Get started now »
  • Mihaela

    Worked for me. Thank you.

  • vaibhav singh

    Hey,

    Thanks for taking time to write this. I was thinking it is impossible to change….Thanks a lot

  • hoa sen vang

    That’s good idea, thanks i think found the right way to change user name any more, which make me crazy time.

  • getnet asfaw

    how can i change user name from the hosted website if i can’t access the database of all the users?

  • Milan

    Thanks
    BTW
    why not choose desired name that appear for that username

  • Jitendra Vaswani

    Thnxxx for this amazing article. I was eager to change my username. finally i got solution.

  • Kamal G

    Very Very Useful Thanks a lot for sharing,it saved lot of time…

  • Dave OSullivan

    Thanks, worked a treat. Instead of ‘Usernames cannot be changed’ why doesn’t it say ‘Usernames can only be changed in your hosting cPanel’ Thanks fir the tutorial

  • Michael Bryant

    Awesome tutorial, thanks for the info. Worked just like the steps you outlined. Thanks.

  • John G.

    That really helped out, thanks for posting it. Really was one, two, and done.

  • Richard

    I have installed probably three wp site recently and my email address is being put in as user id. When I try to change by creating a new admin and delete the old, the system will not complete the action. So now I have two admins in each install.

  • Phillip Taare

    thanks very cool, I used better Wp security plugin but I did like your article. Cheers

  • William Patton

    wow… how many people don’t update their username on creation? lol

    And changing the record in the database without following the chain of records that the original input created is just… wrong. I wouldn’t be giving anyone this advice without a disclaimer. At least it says the easiest way (it should be the recommended way) is to create a new user and attribute all posts to it then make sure that the old user ID isn’t being called from anywhere, if it is update it.

  • Justin

    This was extremely helpful. Thanks for making things easy.

  • Jim White

    Worked for me. Thank you.

  • Chris

    Worked for me thanks!

  • Adnan Gujjar

    thanks for this nice trick, i have changed my username :)

  • Lilou

    I’m French and not English very well. But I wanted to thank you for your help, because I was looking how to change the ID of my WordPress site.

    Thank you again.
    I put your site in my favorites.

    See you soon.

  • Naveen

    thanks a lot
    it worked well for me….

  • https://foxyhare.com/ wisekal

     @Stijn Vogels Changing the username in this manner can also cause other problems. As you mentioned, a person can create a new account, give it admin rights and proceed by deleting the old admin. However, there are in many instances where the admin ID was used for something. When you create a new admin, you create a new ID. By updating the username via “phpMyAdmin” you’re avoiding that being changed.
     
    @kovshenin  This is 100% correct and goes with what I said above. In my opinion the best approach is that which was recommended above in this article. It keeps a lot of the crucial information you may require rather than loosing it when creating a new admin user.
     
    Additionally to all this, you can also download a plugin or two by Website Defender, one being “WP Security Scan” and the other “WP Secure”. These plugins allow for you to seamlessly update your database username and prefix used by your installation without any access required to the databases. Two plugins I strongly recommend for various reasons.
     
    - Bryce Wisekal

    • kovshenin

       @wisekal  Hi Bryce! Sorry but you’re wrong, messing with the wp_users table directly is in fact insecure, because of the various actions and filters run during functions like wp_insert_user and wp_update_user including cache revalidation, data sanitization and much more. When updating your table directly you’re short-circuiting all those actions and filters, so plugins, themes and core that rely on them will simply fail. An example of such a plugin is any persistent object caching plugin that uses wp_cache_get.

  • kovshenin

    Stijn’s right, it’s easier and requires no messy phpMyAdmin routines, to just create a new user and then attribute all posts. However, it’s worth noting that usernames are used in the permalink structure for author archives, like your archives are now on /author/wpbeginner/ and if you changed your username, all those previous links will turn into 404 errors.
     
    ~ Konstantin

    • Stijn Vogels

       @kovshenin Methinks an archive for /author/kovshenin/ would be more relevant than /author/admin/ which will probably generate a million results… According to Google, about 17,3 million. No argument that your procedure is the most valid, but it should be done from the beginning.

      • kovshenin

         @Stijn Vogels I’m not saying it’s good or bad, wrong or right, worth the trouble or not. I’m just saying what will happen to your previous author archives, so nobody is surprised :)

    • http://www.wpbeginner.com Editorial Staff

      Not sure if I understand you correctly Konstantin.. But in my experience, the old URLs stay the same. For example if the URL is /author/wpbeginner/ << it will continue to work.

      For example if I changed the username to newname… the url /author/newname/ won’t work. But that has no impact on anything. As a matter of fact some may even say that this is good for security because now the hackers don’t know your username.

      • GWW

        I believe the URLs use the user_nicename field. By default, this is set to the user_login field after being passed through `sanitize_title` (which replaces accented characters, removes HTML and PHP tags). If you update user_login without changing user_nicename, URLs remain unaffected. If you update both fields, URLs will change; any URL using the old nice name will result in a 404.

        • whereskarlo

          This. What about if you only change the nicename but leave the username intact? I’d rather keep my username and make the urls prettier.

  • Stijn Vogels

    Even easier:
    1. Create a new admin profile for yourself, with the name you want.
    2. Delete you old admin profile and transfer all posts to the new account.
    3. Done.

    • http://defaulttricks.com/ Mohit Bumb

       @Stijn Vogels lol nice :D

    • charmain

      Nice one!! Thanks a……gazillion! Very helpful!

  • http://vilmosioo.co.uk/ Will

    This is so cool! Thanks a lot :) Was wondering how to do this.