Magento ce 2.3.5 installation fails – DDL statements are not allowed in transactions

Trying to install Magento 2.3.5 CE (wit sample data) on Mac Mojave / Apache 2.4.34 / MySQL 8.0.18

 

Installation gets stuck showing some DDL statements errors. I tried several times to redo this using new databases created in MySQL. but similar errors.

 

Option i chose to install.. default + Magento_SampleData

Screen Shot 2020-05-15 at 9.16.54 AM.png

Screenshots:

 

[ERROR] MagentoFrameworkDBAdapterConnectionException: DDL statements are not allowed in transactions in /Users/suren/Sites/magento-ce-2.3.5/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:516
Stack trace:
#0 /Users/suren/Sites/magento-ce-2.3.5/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(544): MagentoFrameworkDBAdapterPdoMysql->_checkDdlTransaction('ALTER TABLE ema...')
#1 /Users/suren/Sites/magento-ce-2.3.5/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(613): MagentoFrameworkDBAdapterPdoMysql->_query('ALTER TABLE ema...', Array)
#2 /Users/suren/Sites/magento-ce-2.3.5/generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php(128): MagentoFrameworkDBAdapterPdoMysql->query('ALTER TABLE ema...', Array)
#3 /Users/suren/Sites/magento-ce-2.3.5/vendor/dotmailer/dotmailer-magento2-extension/Setup/Install/DataMigrationHelper.php(160): MagentoFrameworkDBAdapterPdoMysqlInterceptor->query('ALTER TABLE ema...')
#4 /Users/suren/Sites/magento-ce-2.3.5/vendor/dotmailer/dotmailer-magento2-extension/Setup/Install/DataMigrationHelper.php(100): DotdigitalgroupEmailSetupInstallDataMigrationHelper->emptyTables()
#5 /Users/suren/Sites/magento-ce-2.3.5/vendor/dotmailer/dotmailer-magento2-extension/Setup/InstallData.php(46): DotdigitalgroupEmailSetupInstallDataMigrationHelper->run()
#6 /Users/suren/Sites/magento-ce-2.3.5/setup/src/Magento/Setup/Model/Installer.php(1000): DotdigitalgroupEmailSetupInstallData->install(Object(MagentoSetupModuleDataSetup), Object(MagentoSetupModelModuleContext))
#7 /Users/suren/Sites/magento-ce-2.3.5/setup/src/Magento/Setup/Model/Installer.php(890): MagentoSetupModelInstaller->handleDBSchemaData(Object(MagentoSetupModuleDataSetup), 'data', Array)
#8 [internal function]: MagentoSetupModelInstaller->installDataFixtures(Array)
#9 /Users/suren/Sites/magento-ce-2.3.5/setup/src/Magento/Setup/Model/Installer.php(371): call_user_func_array(Array, Array)
#10 /Users/suren/Sites/magento-ce-2.3.5/setup/src/Magento/Setup/Controller/Install.php(109): MagentoSetupModelInstaller->install(Array)
#11 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(83): MagentoSetupControllerInstall->startAction()
#12 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): LaminasMvcControllerAbstractActionController->onDispatch(Object(LaminasMvcMvcEvent))
#13 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): LaminasEventManagerEventManager->triggerListeners(Object(LaminasMvcMvcEvent), Object(Closure))
#14 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(117): LaminasEventManagerEventManager->triggerEventUntil(Object(Closure), Object(LaminasMvcMvcEvent))
#15 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): LaminasMvcControllerAbstractController->dispatch(Object(LaminasHttpPhpEnvironmentRequest), Object(LaminasHttpPhpEnvironmentResponse))
#16 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): LaminasMvcDispatchListener->onDispatch(Object(LaminasMvcMvcEvent))
#17 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): LaminasEventManagerEventManager->triggerListeners(Object(LaminasMvcMvcEvent), Object(Closure))
#18 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/Application.php(339): LaminasEventManagerEventManager->triggerEventUntil(Object(Closure), Object(LaminasMvcMvcEvent))
#19 /Users/suren/Sites/magento-ce-2.3.5/setup/index.php(39): LaminasMvcApplication->run()
#20 {main}

 

Screen Shot 2020-05-15 at 9.02.25 AM.png