I had my students register themselves this year using email-based self registration. When they had all registered, I removed that as an option, which locked them all out. I then went into phpMyAdmin and changed all the auth fields in mdl_user to 'Manual'.
Now, I am locked out. I am the sole admin so it is essential that I get back in. I still have access to the database through phpMyAdmin but I don't know what to change. The SQL statement I ran was:
UPDATE mdl_user SET auth = 'Manual'
Thanks very much for any suggestions.