Actions

UpgradeError BinaryLoggingTriggerErrors

From Convention Master Documentation

Revision as of 16:24, 24 October 2021 by Trapa (talk | contribs) (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. =...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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;