To achieve this recipe, login to your PhpMyAdmin, select your WordPress database and click on the “SQL” button to open the SQL query window.
Then, paste the following code in the window textarea. Don’t forget to modify the password and username before executing it. Also, make sure you have a backup of your database before executing any SQL queries.
UPDATE wp_users SET user_login = 'New login' WHERE user_login = 'Admin';
Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!
How to manually update your WordPress login