2
You should verify that the db connection details in your mainfile.php is correct. Verify that you can see the database independant of XOOPS using a stand alone app or whatever your host provides. Connect to MySQL and either reset or create a new user/pass for the database and match that in your mainfile.php.