Notifications

54 views

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:

  1. OS Patch that updated the configuration.
  2. MySQL version upgrade updating the configuration.
  3. 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

 

Article Information

Last Updated:2019-06-06 18:10:25
Published:2019-05-24