First, thanks to anyone who takes a look at an issue I can't get to the bottom of regarding a Civi 5.33.2 install.
The issue: When running the installer I get the following error:
Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE
idint unsigned NOT NULL
There is more to the error but I believe I am stuck on permission issue. I seem to be missing a GRANT privilege but I can't find which one I'd need.
Installing CiviCRM 5.33.2 under Drupal 7.78. I have a separate Civi MySQL 5.7 database (running under Centos 8) from my Drupal database but I use the same user to access both databases. I've created the civicrm database as follows:
CREATE DATABASE civicrm CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO 'accessuser'@'localhost' IDENTIFIED BY 'somepassword';
I have the CREATE privilege so it's odd to be told I can't CREATE a table. Any ideas?