MySQL function error - You do not have SUPER privilege

Posted May 17, 2019 3.3k views
MySQLUbuntu 18.04

I cannot create any triggers or procedures in mysql. A message is returned saying ‘You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe logbintrust_creators variable)’

I’ve tried SET GLOBAL log_bin_trust_function_creators=1; but it returns largely the same error (1227) error anyways. How do I log in via root? I cannot find root credentials in wp-config.php. How can I create triggers anyways?

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Maybe you’ve disabled the remote MySQL root access, you could try to first ssh to the droplet and then access MySQL as root locally on the machine.