There are several issues with the database creation. The script is using URF8MB4 which is causing the create segment to run out of space before it can be created:
ErrNo #1071 Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE
key varchar(192) COLLATE utf8mb4_unicode_ci NOT NULL,
Is this a known issue? I am hosting on Siteground and all of the preliminary checks on the environment are green so it should work.