• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Technostarry

  • Home
  • Windows 8
  • Android
  • iOS
  • Web Apps
  • Web Browser
  • Hardware
  • About

Learn How To Change WordPress Admin Username

March 24, 2010 by Saqib 5 Comments

Some people may just think that it’s not possible to change Username in self hosted WordPress blogs. But it’s not so. You can easily change Username in WordPress, even though the “Admin” interface doesn’t have any option to do this. For security reasons also, it’s better to change your default username, which is “admin” to something else. I think WordPress should really consider to include this option to change Username from it’s Admin interface in future releases. Well, till then, let’s learn how to change Username manually.

To change Username in WordPress, follow the below steps:

  1. Log on to your cPanel
  2. Browse to your phpMyAdmin
  3. Now in the left hand side, there should be your WordPress database’s name. Click on it.
  4. Now you will be able to see the tables. Navigate to wp_users table and then click on the Browse button. (“wp” is the WordPress database prefix, and it may be different in your case)

db table

5.  You will be able to see the record of this table. Click on the pen type icon to edit this record. Or see the below screenshot.

6.  Now locate the user_login field, and change the value to your desired new username. So this is how you can change your username in self hosted wordpress blogs.

Note: Follow all these steps with utmost care and if incase of any confusion refer to the screenshots above.

Filed Under: WordPress

Reader Interactions

Comments

  1. Groove Soldier says

    September 24, 2011 at 12:01 am

    Thanks a bunch. You just saved me a BIG headache!
    I was also wondering about changing the username_nicename as well?
    I changed it and it seemed to work fine.

    Reply
  2. dblackherod says

    September 10, 2011 at 8:42 pm

    Saqib is right… the tut works perfectly, even for new wordpress installations (v3.0+).

    One common problem you might encounter with the steps in this tut is the absence of a first_users table in recent WP installations.

    The solution is simple.

    Saqib is probably using “first_” as a db table prefix hence the absence of that table in your installation so simply locate the _users table and then the user-login field and take the tut’s steps from thence.

    Reply
    • Saqib says

      September 10, 2011 at 9:16 pm

      dblackherod you are correct. I have changed this tutorial to reflect wp_users table. wp is the default database prefix for wordpress. Thanks for the clarification, really appreciate it.

      Reply
  3. doug_eike says

    September 2, 2011 at 8:31 pm

    My web host is HostGator, and after I unsuccessfully attempted to change my username, they told me that it is impossible to do so–that the site would break if the username is changed. Fortunately, when I attempted to reset in cPanel, the change I tried to enter did not take, and the username blank reverted to the original one I used when I set up the site.

    Reply
    • Saqib says

      September 4, 2011 at 12:49 am

      This method definitely works, and I hope you have followed this tutorial carefully. Make sure you are editing first_users table only.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

STAY CONNECTED

  • Facebook
  • RSS
  • Twitter
  • YouTube

SUBSCRIBE

Subscribe now to get the latest updates from this blog right to your Inbox

Recent Posts

  • 6 Things to Remember Before Buying a Micro SD Card
  • 5 Best Android Stock Market Apps for India
  • Facebook App Alternatives for Android , and Why You Should Use Them
  • Kindle Oasis vs Voyage vs Paperwhite: Which one to Buy

Footer

Links

  • About
  • Subscribe
  • Contact
  • Advertise
  • Privacy Policy

Books on cloud storage services:

  • Mastering OneDrive And Office Online
  • Mastering Google Drive and Docs (With Tips)
  • Mastering Dropbox with Useful Tips and Apps

Must Read Articles

  • How to Change Default Apps on Android
  • 6 Tips to Increase Battery Life on Android 4.4 KitKat Devices
  • How to Transfer Documents and Files to your Kindle
  • 5 Best Free Offline Dictionary Apps for Android

© Copyright 2016 Technostarry · All Rights Reserved ·