New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Checkit function creation causing error when binary logging enabled - MySQL DB #824

Open

Edwards80 opened this issue Apr 15, 2024 · 1 comment

Edwards80 commented Apr 15, 2024

We have binary logging enabled on a MySQL 5.7 DB but the deploy scripts fail with SQL Error 1419

"You do not have super user privilege and binary logging is enabled"

This error is caused by the creation of the checkit function, however we do not use the function in our verify scripts.

Is there a fix for this that doesn't involve setting log_bin_trust_function_creators to true?

Collaborator

theory commented Apr 15, 2024

I don't know, I would have to defer to a MySQL expert to determine the appropriate solution here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment