Druid (0.8.3) unable to create metadata tables in MySQL (5.7.x)

Druid: 0.8.3
MySQL : 5.7.x

Started Coordinator:

java -Xmx256m -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath config/_common:config/coordinator:lib/* io.druid.cli.Main server coordinator

I ran the SQL query on mysql directly and it throws same error.

Known MySQL issue: https://github.com/druid-io/druid/issues/1701

set global show_compatibility_56 = on;

or

Set show_compatibility_56 = on in /etc/my.cnf and restart mysql server.