Change a WordPress username in PhpMyAdmin

In this guide, we show you how to change a user's login name in the database. This can be useful if you have forgotten your login name, or have a very general username like "admin" that could be easy for hackers to guess.

Tip: If you have more than one WordPress installation on your domain, make sure that you open the right table. You can check this by looking up the table prefix in wp-config.php. If in doubt, you can always contact the support.

1. Open your database in PhpMyAdmin.
2. Click on the database name in the menu to the left. This 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. In the row called user_login, replace the content of the Value field with your new username.
6. Click Go to save your changes. You can now log in with the new username.

Related articles:

• Change the table prefix for WordPress
• Disable file editing in WordPress admin