Problems caused by MySQL 5.6 upgrade: mysql 5.6 upgrade

Problems caused by MySQL 5.6 upgrade: mysql 5.6 upgrade

The MySQL database of the Project was upgraded from 5.5 to 5.6 yesterday. As a result, some tables cannot be updated. The following error is reported:

When @ GLOBAL. ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

MySQL official solution:

"Updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB ."

Https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-restrictions.html

References:

Http://blog.webyog.com/2014/05/12/suddenly-myisam-became-transaction-aware

MYSQL installation problems have been installed many times. The same error is as follows:

If you have installed mysql before, check whether the mysql service has been uninstalled.
Check whether the firewall is disabled!


Mysql 56 configuration problems

The port number should be 9000.
Or do not set