How to change WordPress username through phpMyAdmin

by Mahesh Kukreja on September 4, 2009

  • Share
  • Sharebar
  • Share

Many of you may be knowing that changing WordPress login username is one of the ways to protect your WordPress blog. After a fresh install of WordPress on your host, you sign in with the default username “admin“. You cannot change this username directly from the Admin panel.

But don’t worry! There’s another way to change this username. It’s through phpMyAdmin. This is not a new hack/method. But, it’s quite useful from security point of view, esp. for WordPress newbies.

Following are the steps to change WordPress username through phpMyAdmin:

Step 1: Login to your phpMyAdmin using your SQL Database username and password

phpmyadmin

This can be done through cPanel of your host.

Step 2: Browse to your blog’s database

phpmyadmin

Step 3: Find wp_users:

(Edit the default WordPress table prefix “wp_” if needed)

phpmyadmin

Once you click on browse in your wp_users database, you will be shown the users on this blog. Scroll down to the ID which says user_login as admin(by default). Once there click on edit button, the edit button will appear as a pencil logo.

phpmyadmin

Step 4: Edit the values:

Once clicked on edit, you will be taken to a page that appears as below. Here the second field user_login will have admin under the value column. Change this from admin to anything you prefer.

phpmyadmin

Once done with the change save and click go on the page.

There we have changed the WordPress user from the default admin to something we prefer. This is one way to ensure your WordPress blog is one step secure than it was before.

Happy Blogging.

Subscribe to Email Newsletter

First Name *
Email *
Email Marketing Services You Can Trust

Incoming search terms:

  • phpmyadmin
  • wordpress change admin username phpmyadmin
  • wordpress change username phpmyadmin
  • how to change wordpress username
  • change wordpress username
  • wordpress username
  • change wordpress username in database
  • wordpress change user name
  • how to change login code in wordpress
  • WordPress log in hack

Related Posts
Related Websites

{ 3 trackbacks }

How to change Wordpress username through phpMyAdmin · WP Air
September 4, 2009 at 10:38 am
How to change Wordpress username through phpMyAdmin | Mahesh Kukreja – Webmaster, SEO Blog, Make Money Online
September 13, 2009 at 6:35 pm
MySQL database tricks/tutorial through phpMyAdmin for WordPress | Blog Design Studio
January 11, 2010 at 10:05 am

{ 16 comments… read them below or add one }

Bogcess September 6, 2009 at 1:52 pm

A very detailed information on how to change it. Keep it up and more power!

Reply

PAB September 7, 2009 at 8:05 pm

Nice one. could be useful for me in the future.

Reply

uday September 10, 2009 at 6:55 am

Thanks – Actually got bored with admin!

Reply

Nasif September 19, 2009 at 1:16 am

Lol uday. Same here got bored with admin hehe

Reply

Nerissa Marbury January 20, 2010 at 10:25 am

Thank you! I am in the process of manually reinstalling my wordpress and this post was extremely helpful.

Reply

Cole April 28, 2010 at 7:56 pm

I figured it was this easy but didn’t know if it might affect my posts and such. Good to see it doesn’t!

Reply

JD May 9, 2010 at 1:08 am

Thanks for posting this great tutorial!

JD

Reply

Russell Renkes December 6, 2010 at 5:00 am

Thanks for the information, I already change the prefix wp_ to something else for security reasons, and never really thought much about changing the user name. Everything we can do to keep our blogs a little more secure is always worth doing these days. Thanks again, great post.
Russell Renkes recently posted..Easily Backup Your WordPress Blog

Reply

Thomas December 23, 2010 at 3:24 am

AWESOME….I always wondered how you could change you username if anything ever happened to my wordpress blog. What else can phpmyadmin do I wonder?
Thomas recently posted..Want to Buy a Website Name from a Domain Broker

Reply

Alex January 19, 2011 at 6:08 pm

Thanks, worked perfectly!

Reply

Vivek Parmar January 21, 2011 at 2:16 pm

tha ks for the step-by-step guide tutorial, changing default username is necessary to make your blog secure
Vivek Parmar recently posted..Make Money By Author Advertising WordPress Plugin

Reply

Michel Theriault March 1, 2011 at 5:49 am

I just followed your instructions and it worked like a charm. A big thank you!
Michel Theriault recently posted..Domains Dropping on March 1

Reply

Donna Cooper April 7, 2011 at 8:31 pm

THANK YOU so very much for your very detailed instructions WITH PICTURES! I followed them exactly and it worked PERFECTLY. You are a generous and kind person to offer this info. Thanks again.

Reply

Tousif May 25, 2011 at 1:12 pm

Thanks Mahesh,

Perfectly executed. :)

Reply

TechMafia November 11, 2011 at 6:20 pm

I have changed my user name by reading this article.
thanks

Reply

Vipul November 26, 2011 at 7:50 pm

Great tutorial. Very helpful.
Many many thanks.

Reply

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

CommentLuv badge
 

Previous post:

Next post: