cPanel - MySQL upgrade Sunday April 15, 2018
Posted by Barry Tarbet on 08 April 2018 01:54 PM
Features Added in MySQL 5.7
One of the major changes in MySQL 5.7 is the data integrity has been improved to be more in line with what veteran developers and DBAs expect. Previously, MySQL would adjust incorrect values to the closest possible correct value, where under the new defaults (strict mode) it will instead return an error instead of a warning.
Meaning - when adding data, the tables are more strict, when data is being added to table, the data must match exactly as table is defined.
If you are using a recent version of Wordpress, Drupal, or Magento the good news is that you do not need to do anything.
Suggestions on How to Transition
If you are currently building a new application, then it may be a good idea to change the configuration of your existing MySQL 5.6 databases to behave with the sql_mode settings that are shipped in MySQL 5.7.
Features Deprecated in MySQL 5.7
Features Removed in MySQL 5.7