
Normally you change a WordPress email from your profile and confirm it from a link sent to the new address. When that email never arrives, or you can no longer open the old inbox, you are stuck. This Seahawk Learn video shows a reliable fix: edit the email, username and password directly in the database with phpMyAdmin, even when you are completely locked out of the admin area.
Because you are editing the database by hand, this article also covers the precautions to take first.
Why the normal method fails
In your profile you can enter a new email address, but WordPress sends a confirmation message and waits for you to click the link. If the message is blocked, goes to spam, or your server cannot send mail at all, the change never completes. Password resets work the same way: the reset link goes to the email on file, so if that address is wrong or inaccessible, the reset is useless.
If you only forgot the password and still have access to the email, the built-in tools are simpler. See our guides on recovering a lost WordPress password and how to recover your WordPress password and username. Use the database method when those routes are closed.
Before you edit the database
- Take a backup. Export the database in phpMyAdmin or use your host's backup tool. A wrong edit in the wrong table can break a site.
- Edit one row at a time. Only change the fields you need.
- Be sure of your access. You need a login to your hosting control panel, which is why this works even if WordPress is locked.
Step-by-step: change your details in phpMyAdmin
- Log in to your hosting control panel. The video uses cPanel. Find the Databases section and open phpMyAdmin.
- Identify the right database. Hosting accounts often hold several databases. If you are unsure which one belongs to your site, open the wp-config.php file in your site's files and look for the DB_NAME value. That is the database your site uses.
- Open the database and find the options table. Tables normally have a prefix, usually wp_, though it can differ. Open the table ending in options.
- Edit the admin email. In the options table, look for the row named admin_email. Edit it and enter the new address. This is the site-wide administration email found under Settings, General.
- Edit the user's email. Open the table ending in users. Find the row for your account, edit the user_email field and save.
- Change the username if needed. In the same row, edit the user_login field. WordPress does not normally let you change this in the dashboard, which is why the video presents it as a bonus step.
- Set a new password. In the same row, edit user_pass. In the Function dropdown beside the field, choose MD5, type your new password in the value box and save. WordPress still accepts MD5 and replaces it with its own stronger hash the next time you log in.
- Log in and test. Sign in with the new details. Then change your password again from the profile screen so it is stored with WordPress's current hashing.
Which email is which?
Two different addresses are involved, and mixing them up is a common source of confusion:
- The site admin email (the admin_email option) receives system notices such as update and new-user messages.
- A user's own email (user_email) is used for password resets and notifications to that account.
If you want to receive resets, make sure the user's email is the correct one. Any other users who need changes require their own rows edited.
Fixing the root cause: email delivery
If confirmation emails never arrive, the server may not be sending mail properly. Installing an SMTP plugin so WordPress sends through a real mail account usually fixes it. Our roundup of the best WordPress email plugins lists options worth considering.
Security tips afterwards
- Use a strong, unique password and store it in a password manager.
- Avoid a username like "admin", which attackers try first.
- Review the other administrator accounts under Users and remove any you do not recognise.
- Delete any backup or export files you left on the server.
When not to use this method
If you can still log in, change your email or password from the dashboard instead. WP-CLI is another safe route if you have SSH access: it can set a user's password with one command. The database method suits situations where nothing else works.
What the video covers
- 0:00 Intro: the WordPress email change problem
- 1:03 The normal way (profile settings) and why it fails
- 1:36 Solution: access your cPanel
- 2:33 Multiple databases: how to identify the right one
- 4:18 Locating your database in phpMyAdmin
- 5:19 Editing the admin email directly
- 6:33 Editing specific user email addresses
- 7:41 Bonus: changing your WordPress username
- 8:00 Changing your password using MD5
- 9:22 Final result: username, password and email changed
Is the database method right for you?
Use it when you are locked out and the email route is closed. Back up first, change only what you need, and log in to confirm each change. Afterwards, fix your email delivery so you do not end up in the same position again.
FAQs
Can I change my WordPress email without confirmation?
Yes, by editing the user_email field in the users table and the admin_email option in the options table through phpMyAdmin. This skips the confirmation message entirely.
Is it safe to set a password with MD5 in phpMyAdmin?
It is an accepted method for getting back in. WordPress recognises the MD5 value, and replaces it with a stronger hash once you log in. Change the password again from your profile afterwards.
How do I know which database belongs to my site?
Open wp-config.php in your site files and check the DB_NAME value. That is the database WordPress uses.
Can I change my WordPress username?
Not from the dashboard in a standard install, but you can edit the user_login field in the users table. Create a backup first.
