3
To set it back to use the MySQL database, use phpMyAdmin or something equivalent to edit the field in the database.
use this query to view the record that needs to be changed: (also replace with your prefix.)
SELECT * FROM `_config` where `conf_name` = 'auth_method'
Set the 'conf_value' for that record to 'xoops' and it should use the MySQL database again.