UpgradeError BinaryLoggingTriggerErrors: Difference between revisions
From Convention Master Documentation
(Created page with "==Error: You Do not have "Super" privileges, and Binary Logging is enabled== This error can occur after a upgrade, and your DB is trying to re-create the triggers needed. =...") |
(No difference)
|
Latest revision as of 16:24, 24 October 2021
Error: You Do not have "Super" privileges, and Binary Logging is enabled
This error can occur after a upgrade, and your DB is trying to re-create the triggers needed.
Fix: Update the log_bin_trust_function_creators Setting in mysql
From the command line log into your server, and Log into mysql using a user with permission.
server>mysql -u USERNAME -p mysql>set global log_bin_trust_function_creators=1;