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

[surenkonathala]

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

Screenshots:

[ERROR] Magento\Framework\DB\Adapter\ConnectionException: 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): Magento\Framework\DB\Adapter\Pdo\Mysql->_checkDdlTransaction('ALTER TABLE ema...')
#1 /Users/suren/Sites/magento-ce-2.3.5/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(613): Magento\Framework\DB\Adapter\Pdo\Mysql->_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): Magento\Framework\DB\Adapter\Pdo\Mysql->query('ALTER TABLE ema...', Array)
#3 /Users/suren/Sites/magento-ce-2.3.5/vendor/dotmailer/dotmailer-magento2-extension/Setup/Install/DataMigrationHelper.php(160): Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query('ALTER TABLE ema...')
#4 /Users/suren/Sites/magento-ce-2.3.5/vendor/dotmailer/dotmailer-magento2-extension/Setup/Install/DataMigrationHelper.php(100): Dotdigitalgroup\Email\Setup\Install\DataMigrationHelper->emptyTables()
#5 /Users/suren/Sites/magento-ce-2.3.5/vendor/dotmailer/dotmailer-magento2-extension/Setup/InstallData.php(46): Dotdigitalgroup\Email\Setup\Install\DataMigrationHelper->run()
#6 /Users/suren/Sites/magento-ce-2.3.5/setup/src/Magento/Setup/Model/Installer.php(1000): Dotdigitalgroup\Email\Setup\InstallData->install(Object(Magento\Setup\Module\DataSetup), Object(Magento\Setup\Model\ModuleContext))
#7 /Users/suren/Sites/magento-ce-2.3.5/setup/src/Magento/Setup/Model/Installer.php(890): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data', Array)
#8 [internal function]: Magento\Setup\Model\Installer->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): Magento\Setup\Model\Installer->install(Array)
#11 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(83): Magento\Setup\Controller\Install->startAction()
#12 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#13 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#14 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(117): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#15 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#16 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#17 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#18 /Users/suren/Sites/magento-ce-2.3.5/vendor/laminas/laminas-mvc/src/Application.php(339): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#19 /Users/suren/Sites/magento-ce-2.3.5/setup/index.php(39): Laminas\Mvc\Application->run()
#20 {main}

[shikha1193]

Hi @surenkonathala 

Your issue seems similar to query on stackexchange Please check this
https://magento.stackexchange.com/questions/277432/error-ddl-statements-are-not-allowed-in-transacti...

If problem solved click Kudos and Accept as answer

[surenkonathala]

That maybe a solution.. 

create a db_schema.xml file under Vendor/ModuleName/etc

1. But why should we create a new xml file?
2. Does the product work/install out-of-the-box without such changes to core modules?
3. Not sure if this is mention din the installation notes?

[Vimal Kumar]

Hi @surenkonathala 

MySQL version 8.0 is not recommended by Magento doc, it is tested with MySQL 5.6, 5.7.

More more info:

https://devdocs.magento.com/guides/v2.3/install-gde/system-requirements-tech.html

I hope it will help you!

[surenkonathala]

Thanks @Vimal Kumar we will try. Glad it was mentioned somewhere.