What are the DB Privileges needed?

[bragot]

According to documentation, the following privileges are needed for the DB user:

The database user needs the permissions for CREATE, DROP, INSERT, UPDATE, DELETE and SELECT on all tables in the database.

I seemed to do this, but I get the following error when trying to run the installer script:

Error: Please install your version of phpMyFAQ once again or send us a bug report.
DB error: INDEX command denied to user 'faq1'@'localhost' for table 'faqsessions'
Query:
CREATE INDEX idx_user_time ON faqsessions (user_id, time)

Here are the steps I followed to install phpmyfaq:

1. Downloaded and installed XAMPP for windows using the EXE installer
2. Extracted phpmyfaq to a folder called faq under htdocs
3. Opened phpmyadmin and created a user called faquser
4. Created a new db call faqdb with collation utf8_unicode_ci (default setting)
5. Under privileges of faquser, granted the following global privileges:

CREATE, DROP, INSERT, UPDATE, DELETE and SELECT

When I try to install though, I get the error above. If I grant faquser all privileges, this will work correctly though. Does anyone have any suggestions?

Thanks.

[Thorsten]

Hi,

I think you need the right to create indeces, too.

bye
Thorsten