This brief tutorial shows students and new users an easy way to change your WordPress username using cPanel and phpMyAdmin.
For new webmasters, setting up WordPress the first time may not be the end of the story. Sometimes you make changes that may not be right and you’d like to undo them. Like choosing the wrong account name for WordPress administrator.
When you’re setting up WordPress the first time, you’re given an opportunity to create an administrative account name. This name will be the default username for the account. When you create it, it gets added to the database and you can not change it from WordPress dashboard.
If you made a mistake choosing the account name, you will have to change the name from WordPress database, and this is where cPanel comes into play.
Since most new users are going to be managing their websites and blogs with help of a host provider, most times, these host providers allow user to use cPanel and other hosting tools to manage their websites.
cPanel comes with a database management tool called phpMyAdmin. One can use this tool to manage MySQL databases. If you need to change WordPress username, you will certainly use phpMyAdmin to do it.
Step 1: Accessing phpMyAdmin from cPanel
To access phpMyAdmin from cPanel, logon to your cPanel account (your host provider should make this available to you). Then in the Databases section, select phpMyAdmin as shown in the image below
Step 2: Changing WordPress Username
When phpMyAdmin opens, it should automatically show a list of databases on the left. Select and expand the database WordPress it using. The expanded database displays all the tables in the database.
Next, select the wp_users table to show a list of current WordPress users as shown in the image below
Then click the Edit link of the account you wish to edit. When the table opens, change the value for the column ID user_nicename to what the username to be and save your changes.
When you’re done, go to your WordPress admin page and attempt to logon with the new username and the same password and it should work.
This is how one changes WordPress username using phpMyAdmin.
You may also like this post:
Lesson 27: Use MySQL Wizard in cPanel to Create Databases