The table with the passwords is <your prefix>_users (xoops_users ?) and the user password field is "pass". The user id field is "uid", the name field is "uname". Pretty basic stuff.
The other details should already be known if you've installed xoops.
I myself wouldn't use a Fantistico install but if you don't have a clue it is the easy way. You can then use the db admin tool (phpMyadmin?) app on your control panel (cPanel?) to look into the database for more details. Normally you don't need to know the nitty gritty.