Is there any update on this?
is this linked default character set utf8mb4 while revive requirement is (CHARACTER SET utf8 COLLATE utf8_general_ci).
referring to this Installation failed to create the core tables · Issue #740 · revive-adserver/revive-adserver · GitHub
It did not help me even after changing this.