I'm trying to switch from MariaDB 10 to MySQL 5.6 (run into issues restoring a Magento 2.2 database). Did all the necessary steps but the switch fails with the following log. How can I fix this and get MySQL 5.6 up and running (a clean install will be fine as well).
Code:
This is a brief description of the upgrade process. Important details
can be found in the MySQL manual, in the Upgrading section.
******************************************************************
error: %pre(MySQL-server-5.6.42-1.el6.x86_64) scriptlet failed, exit status 1
error: MySQL-server-5.6.42-1.el6.x86_64: install failed
2:MySQL-devel-5.6.42-1.el6 ################################# [ 50%]
3:MySQL-client-5.6.42-1.el6 ################################# [ 75%]
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Phase 1/7: Checking and upgrading mysql database
# Connecting to localhost...
# Disconnecting from localhost...
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
/usr/bin/mysqlcheck: unknown variable 'process-views=YES'
FATAL ERROR: Upgrade failed
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
cp: '/usr/lib/libmysqlclient.so.18' and '/usr/lib/mysql/libmysqlclient.so.18' are the same file
Restarting MySQL.
