Hi,
I have found that is necessary to provide permission to create SQL tables (in addition to SELECT, DELETE, INSERT, and UPDATE, which are already needed by WP). Things appear to work when either permanent (CREATE) or temporary (CREATE TEMPORARY TABLE), or both, creation is allowed. As I don’t know all of the details of what is happening in the code, I have just allowed both, and things seem to be working fine. I’ll let you know if any other issues arise.
Mark,
Thank you for your reply. I have just determined the cause of this (via examination of the error_log), and it is to neither my host’s fault or yours. The issue is with the permissions given to the admin of the SQL database. Typically, for security, I only allow SELECT, DELETE, INSERT, and UPDATE. However, this caused Wordfence to not operate correctly (probably due to it not being able to create its own tables?). Can you tell me the minimum set of permissions that I should to give the SQL admin for Wordfence to operate, so that I need not use ALL PERMISSIONS?
Thanks.
