Change a WordPress username in PhpMyAdmin

In this guide, we show how you can change the login name for a user in the database. This can be useful in case you have forgotten your login, or if you have an insecure a username like “admin”.

1. Open your database in PhpMyAdmin.
2. Click on the database name in the menu to the left, it will unfold all tables.
3. Click on the users table, for example, wp_users.
4. Locate the user you want to change the login name for and click Edit.

5. Under user_login, change the value with your new username.
6. Click Go to save your changes. You can now log in with the new username.

Enjoy!