(Might not be an answer but posting as answer since this won't fit in a comment.)
See https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-permissions. You don't have REFERENCES permission.
What's the full error if you run the create table manually? It looks like this:
CREATE TABLE `civicrm_acl_cache` (
`id` int unsigned NOT NULL ...