3
Xoops attempts to create the table for you.
If you have a user account name and password, the XOOPS installer will try to take it from there. It is also helpful to have the address of MySQL server, in case it is not "localhost".
Give it a shot. Let us know what happens.