Database

Database user needs permissions to create tables.

When Wordfence installs it needs to be able to create a few database tables. If your database doesn’t allow WordPress to create tables, then you need to add the “create” permission to the user that WordPress connects as. You can do this in phpmyadmin. The following are instructions for phpMyAdmin Version 4.1.5:

Select the database used by WordPress

Select the top tab Privileges

Click "Edit Privileges" next to the user WordPress connects as which you can find in your wp-config.php file next to DB_USER. The file is in the root of your WordPress installation

Under Structure, click the CREATE box

If you don’t use phpmyadmin, then you need to contact your site administrator, web host or database admin and ask them to allow WordPress to create tables in the database.