Topic: Xoops install error

[Drifting]

Followed Howto on this site, created a user with Update,Create,delete. well that was as near as I could work out as the Howto said "Create a mysql user with the access rights to create, modify, and delete mysql dbases"

Anyway the wizard ran fine, but at the last stage I got the following: -

 Failed inserting 1 entries to table xoops_bannerclient.
 Failed inserting 6 entries to table xoops_configcategory.
 Failed inserting 27 entries to table xoops_configoption.
 Failed inserting 1 entries to table xoops_imgset.
 Failed inserting 1 entries to table xoops_imgset_tplset_link.
 Failed inserting 7 entries to table xoops_ranks.
 Failed inserting 17 entries to table xoops_smiles.
 Failed inserting 3 entries to table xoops_groups.
 Failed inserting 2 entries to table xoops_groups_users_link.
 Failed inserting 55 entries to table xoops_group_permission.
 Failed inserting 3 entries to table xoops_banner.
 Failed inserting 1 entries to table xoops_tplset.
 Failed inserting 1 entries to table xoops_modules.
 Failed inserting 26 entries to table xoops_tplfile.
 Failed inserting 26 entries to table xoops_tplsource.
 Failed inserting 12 entries to table xoops_newblocks.
 Failed inserting 1 entries to table xoops_users.
 Failed inserting 71 entries to table xoops_config.


This is not a life or death problem, I am just on a learning curve and playing.

Paul.

[Brave Dave]

Pretty sure you have just omitted to grant the permissions;

1. Log into the sme server (ssh)
2. fire your mysql client
3. grant all on [database].* to [user]@localhost;

where;
* database would equal xoops database
* user would equal xoops user

[Drifting]

That was it, thanks  

Now what are the exact rights I should set for the xoops database user? Would like it to be secure if possible  

Paul.