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

This can be done through cPanel of your host.

Step 2: Browse to your blog’s database

Step 3: Find wp_users:

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

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.

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.

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.

Other posts by Mahesh Kukreja

Incoming search terms:

• phpmyadmin
• wordpress change username phpmyadmin
• wordpress change admin username phpmyadmin
• wordpress username
• how to change wordpress username
• change wordpress username in database
• change wordpress username
• wordpress change username database
• how to change login code in wordpress
• wordpress change username

• Promoting Your Brand Through Partnerships With Bloggers
• Disable Wordpress plugins through phpMyAdmin
• How to change Wordpress Password through phpMyAdmin
• How To Blog Consistently
• 10 Do’s And Don’ts To Increase Your RSS Count!

• Network Marketing Blogs - Wordpress Vs Blogger
• Professional Blogging Roundup: The Early Veteran's Day Edition
• Sunday Roundup: Corporate Blogging, Web Traffic and SEO Tips
• 6 + 1 Steps for How to Increase Blog Traffic
• How to Set Up a Self-Hosted WordPress Blog in 8 Easy Steps

{ 19 comments }