If you have an existing WordPress site and you want to change your username(to something different than “admin” for security reasons, for example), you can do this quite easily.

First, go to your cPanel and click on the phpMyAdmin icon in the Database section.
nu1

Next, locate your WordPress database from the list on the left.

nu2

If you’re not sure which one it is, you can check the wp-config.php file in the root folder of your WordPress installation and in particular the line below:

define('DB_NAME', 'user_wp448');

Once you select your WordPress database, you will see a lit of its tables. Choose the _users table from the left menu.

nu3

You will see a list of all the registered users in your site. Locate the admin username and click on theEdit button on that line.

nu4

Now, you will see all the fields for this username. Locate the user_login field and replace its value from admin to your new preferred WordPress login name and hit the Go button at the bottom of the page.

nu5

That’s it, you can now login with your newly selected WordPress username!