beehexa integrationsidebar
beehexa beehexa logo 1

We Build HexaSync Integration Platform for Connecting ERP, POS, CRM, Accounting, and eCommerce Applications to Automate Business Processes

How to fix if there is no such engine: mysql2 in Magento 2.1.10?

Magento Errors: no such engine

Magento 2.1.10 contains almost 40 security fixes and functional enhancements so it will bring a lot of benefits of
your online store owner to upgrade to this latest version.


I also did that some days ago for my clients, but I encountered a strange error.

Catalog Search indexer process unknown error: There is no such engine: mysql2

After doing some research, I figured out this process to sort out the above issue according to these steps:

# run this query
UPDATE core_config_data set value = 'mysql' where path='catalog/search/engine';
# and run these commands
php -f bin/magento setup:upgrade
php -f bin/magento cache:flush
php -f bin/magento indexer:reindex

I hope this small tip can save you the time of upgrading to the latest Magento 2.1.10 version.

Table of Contents

Ready to integrate and automate at scale ?

Learn how HexaSync lets you build enterprise-grade integrations and automations without having to code.

Receive Exclusive Productivity Tips Directly in Your Inbox

We’ll email you 1-3 times per week—and never share your information.

Get started for free

You can’t add more hours to the day. Beehexa is the next best thing.