Hey Yall,
I will pass on the "which is better CMS". I have a site using Xoops and one using phpWebsite. To each their own, if it works for your needs, then it is the best.
As for the MySQL databases that is needed for Xoops.
Here is my settings:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES.
These settings are only for the "Xoops DB user", they are not GLOBAL. I have a GLOBAL user set up just for backing up the DB's.
I read somewhere about minimizing privileges to keep security tight, sorry I don't have the link.
Hope this helps.
Joe