July 25, 2017
In MySQL 5.7, if you execute the query from Tom Mac’s answer, you will get the following error:
ERROR 3167 (HY000): The ‘INFORMATION_SCHEMA.SESSION_VARIABLES’ feature is disabled; see the documentation for ‘show_compatibility_56’
You should query performance_schema
instead. Run the following:
SELECT variable_value FROM performance_schema.session_variables WHERE upper(variable_name) = 'BINLOG_FORMAT';