Error Message: "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" .

The following error message appears while performing any operation that alters a table:

Error Message: "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)".

MySQL 5.5, 5.6 and MariaDB 10.1, 10.2

Self-Hosted MySQL: The issue is only seen on self-hosted instances having log_bin_trust_function_creators = 0 in the MySQL my.cnf file.

Possible causes of having the incorrect MySQL configuration could be:

1. OS Patch that updated the configuration.
2. MySQL version upgrades, updating the configuration.
3. Manually updating the configuration (while setting up replication maybe).

Update the setting in the my.cnf Configuration file on the MySQL server. Find the setting 'log_bin_trust_function_creators' and set it as follows:

log_bin_trust_function_creators = 1

The location of the file is generally something like:

/glide/distribution/ServiceNow_mysql5.6_my.cnf-256GB /etc/my.cnf