MySQL升5.6引發的問題，mysql升5.6

MySQL升5.6引發的問題，mysql升5.6

昨天項目MySQL數據庫從5.5升級到5.6，導致部分表無法進行更新操作，報如下錯誤：

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官方給出的解決辦法：

“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

參考文章：

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

MYSQL安裝問題，裝了mysql5617好多次了，同樣的錯誤，截圖如下，指導

如果你之前有安裝過mysql，檢查之前的mysql服務是否已經卸載干淨。
檢查一下權限，防火牆是否已關閉！

 

mysql 56配置問題

端口應該是9000
或者不設置