My web host is currently planning to upgrade all servers from MySQL 5.6 to 5.7 next week (and just informed us today for the first time). I have done a little digging and have not found any real clarification if CE 1.9.0.1 runs on 5.7 or not, and from what little I have found, I am leaning towards the side of it not being compatible. So my question becomes, does anyone have any experience with 1.9.0.1 and MySQL 5.7 and if so, what precautions do I need to take, or is this just going to be a bumpy ride?
Magento – Is CE 1.9.0.1 compatible with MySQL 5.7
databasemagento-1.9
Best Answer
Magento 1.9 is compatible with MySQL 5.7. You may have a bit of a bumpy start if you have to manually set the sql_mode parameters but in most cases it goes well.
I would heavily suggest however testing on a development server first so if you have to set the params manually you will know what to do as soon as the live version switches. You can take a dump of your database, install magento on the new DB then import the dump to get the best chance of no issues.