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”.
- Open your database in PhpMyAdmin.
- Click on the database name in the menu to the left, it will unfold all tables.
- Click on the users table, for example, wp_users.
- Locate the user you want to change the login name for and click Edit.

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

Enjoy!