Symptoms
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)"
Release
MySQL 5.5, 5.6 and MariaDB 10.1, 10.2
Environment
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.
Cause
Possible causes of having the incorrect MySQL configuration could be:
- OS Patch that updated the configuration.
- MySQL version upgrade updating the configuration.
- Manually updating the configuration (while setting up replication may be).
Resolution
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