Fatal MYSQL error on install: REFERENCES command denied to user
Created by: jenlampton
I am trying to add CiviCRM to an existing Backdrop site.
I was able to download the module from the CiviCRM website, and enable via the modules page. Then I navigated to civicrm/setup
and once I resolved the permissions issue with triggers, I attempted to load default content by ticking the box next to Load sample data
.
As soon as I hit "Install CiviCRM" I was greeted with the fatal error:
Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE `civicrm_acl_cache` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID', `contact_id` int unsigned COMMENT 'Foreign Key to Contact', `acl_id` int unsigned NOT NULL COMMENT 'Foreign Key to ACL', `modified_date` timestamp NULL COMMENT 'When was this cache entry last modified' , PRIMARY KEY (`id`) , INDEX `index_contact_id`( contact_id ) , INDEX `index_acl_id`( acl_id ) , INDEX `index_modified_date`( modified_date ) , CONSTRAINT FK_civicrm_acl_cache_acl_id FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: REFERENCES command denied to user 'backdrop'@'localhost' for table 'civicrm_acl' in Civi\Setup\DbUtil::sourceSQL() (line 204 of backdrop/modules/contrib/civicrm/setup/src/Setup/DbUtil.php).
Now all pages under /civicrm/
(includin civicrm/setup
) show the page "CiviCRM Installed" with the message "CiviCRM has been successfully installed" but I don't think it has installed. If it had, I'd be able to see and or use civi in here somewhere, wouldn't I?