Questions that are too localized (such as syntax errors, code with restricted access, hacked sites, hosting or support issues) are not in scope. See how do I ask a good question?
Closed 4 years ago.
Improve this questionI can't find a single answer to get me past this, so I changed the email address in wordpress, but while doing so, I was trying to add 2 emails with a ',' in between, but I made a type, and entered
[email protected]
A complete mess of two emails, however now I can not change it at all, if I reset, we confirm the new admin, nothing, if I go into myphpadmin and change it in options, it won't change, nothing I do will change it's email (how can myphpadmin not overwrite this)
Also what If I delete it in myphpadmin, what would happen??
Closed. This question is off-topic. It is not currently accepting answers.Questions that are too localized (such as syntax errors, code with restricted access, hacked sites, hosting or support issues) are not in scope. See how do I ask a good question?
Closed 4 years ago.
Improve this questionI can't find a single answer to get me past this, so I changed the email address in wordpress, but while doing so, I was trying to add 2 emails with a ',' in between, but I made a type, and entered
[email protected]
A complete mess of two emails, however now I can not change it at all, if I reset, we confirm the new admin, nothing, if I go into myphpadmin and change it in options, it won't change, nothing I do will change it's email (how can myphpadmin not overwrite this)
Also what If I delete it in myphpadmin, what would happen??
Share Improve this question edited Feb 8, 2021 at 15:37 fuxia♦ 107k38 gold badges255 silver badges459 bronze badges asked Feb 8, 2021 at 15:02 user3593556user3593556 132 bronze badges 3- personally, I can change my own in options via phpmyadmin. but, if you can't, try export it first, and edit .sql file with notepad or other text editors. and then delete the options table in phpmyadmin, and import the edited one. – Tiyo Commented Feb 8, 2021 at 15:24
- If PHPMyAdmin cannot change the value of that row then this is not a WordPress problem. Please confirm that the SQL user you are using has the necessary privileges to write to that table, what you describe is not normal behaviour – Tom J Nowell ♦ Commented Feb 8, 2021 at 15:59
- You need to speak with your hosting provider if direct SQL queries cannot change the row in the database. Nothing on the WP side can fix that – Tom J Nowell ♦ Commented Feb 9, 2021 at 10:50
2 Answers
Reset to default 1You can't have more than one admin email, if you need it to arrive in more than one inbox then you need to do that at the other end, via a mailing list or forwarding rules, etc
I don't know how you set the admin email to an invalid email address with commas, but, you can fix this by setting the option directly to the email you want. As you have PHPMyAdmin you can do this directly in the options table
For example, I changed the admin_email
option from [email protected]
to [email protected]
:
Now the admin email address is [email protected]
. Notice it has a pending change to [email protected]
, this is because new_admin_email
was not changed. Deleting the new_admin_email
option will fix this, as will clicking cancel.
If you have other admin users you have no problems otherwise if you are not sure to avoid damage, before all create a new admin user via phpmyadmin. Login in wp-admin with the new credentials and modify or delete the old admin