I changed the email address for admin in the mysql member table.
Since that time, I cannot log in as admin. It keeps reporting that the credentials are not correct.
If I request a password reset, I get the link sent to me, enter my new password and I am logged in as admin.
If I logout and attempt to log in again with the new password, it still does not work.
For the meantime, I have added Security::setDefaultAdmin to my _config.php file and I can log in using that password.
Any ideas on what is not working, or how I can check?
Just to make sure - did you actually change it in the Member table by hand or the intended way, by using the CMS? As this happened immediately after changing the e-mailaddress, you could try changing it to another e-mailaddress, or reenter the current one, by typing it by hand - not pasting it in.
I've had problems like this in the past where a hyphen was replaced by a special character version (pasting fronm Word :( )
I changed the email address directly in phpmyadmin, not via the CMS.
Since I had not changed it via the CMS, I thought if I reset the password via the CMS, then maybe it would right my wrong.
I will try restoring the record completely from a previous back up and see if that works,
I restored the member record that I altered manually in phpmyadmin back to its original by restoring from a sql dump I had taken previously.
Once restored, I could log in correctly to CMS as admin without an issue.
Once in the CMS, I changed the admin email address (using the CMS) and logged out.
Once again I could not log in.
So meantime I have restored the original member record.
Never occurred to me that SS has no concept of a separate username. The email address is the username, so changing the email address for admin, changes the username for admin. Doh!
So once changed, I can no longer login as admin.
Seems obvious now.