As we all know that now a days majority blogs on web are powered by WordPress. This is because WordPress is the most flexible Content management system till now. To access admin panel of your site, You have to enter Your Username and password you’ve selected while installing WordPress.
Sometime it happens that you want to change username in WordPress but its not allowing you to change. Recently, My Username for this site was so simple and i thought that lets do experiment to change WordPress username and successfully changed also. Here is video and if you want text tutorial then proceed further…
So, How to Change WordPress Username?
I hope that you know that WordPress uses MySQL database to store the data of website. WordPress also stores Usernames and Passwords of registered users in MySQL database. So, You can’t change username from WordPress admin panel. To change your wordpress username, You have to visit phpMyAdmin. You can visit phpMyAdmin from the cpanel of your hosting provider.
Just click on phpMyAdmin from your cPanel and then it will be redirected to phpMyAdmin. If you are geek like me and not using any cPanel based hosting then you know where you can access phpMyAdmin.
In the left sidebar of phpMyAdmin, You will get the list of the databases. Click on the database you are currently using for your site. After selecting database, You will get the list of the tables you have on your database.
In the list of tables, You will get the table named
wp_users which contains the login and contact information of every users of your site. In the list of tables in database, You will get the table named
wp_users in which you will get login and contact information about registered users of your site.
If you are the only registered user of the site you will see only single entry of yours and you can simply edit that, In my case I have many users, so I will look for mine and edit that only.
You can see that the
user_login row shows usernames of the corresponding user. Currently in my test scenario username is admin.
Now, The last thing you have to do is to change your username and save the record.
Enter the new username replacing old one; and to save it come down and click on Go button with a default selected options. If Save is not default then select Save from dropdown menu then click Go. Now you have successfully changed the wordpress username.
Note: Don’t try to change password from here because here your password is encrypted. If you will try to change then it may harm your whole site.
By this method, You can successfully change your wordpress username. You can also change usernames of other registered users if they want.