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.
Next, locate your WordPress database from the list on the left.
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.
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.
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.
That’s it, you can now login with your newly selected WordPress username!