Resolution
Check my.ini or my.cnf of mysql
See if GTID replication is enabled by looking at this variable: enforce_gtid_consistency.
This variable is by default set to false in MySQL, it is related to MySQL replication.
Database doesn't allow temporary tables to be created within a transaction if that variable is enabled. This causes problems for the server since it uses temporary tables quite a lot.
If this variable is ON, please turn that OFF.