SQL Fail during upgrade Confluence 7.9.1 to 7.13.0

[Yevhen Nahornyi]

Hello! Today I try to upgrade my Confluence Server from 7.9.1 to 7.13.0

And now I got the error message in my browser

Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade. Upgrade error message: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DenormalisedSpacePermissionsUpgradeTask@35855905 failed during the SCHEMA_UPGRADE phase due to: StatementCallback; uncategorized SQLException for SQL [DROP TRIGGER IF EXISTS denormalised_space_permission_trigger_on_update;]; SQL state [HY000]; error code [1419]; 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); nested exception is java.sql.SQLException: 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)

MSQL version

mysql  Ver 14.14 Distrib 5.7.35, for Linux (x86_64) using  EditLine wrapper

JDBC driver for MySQL --  mysql-connector-java-8.0.26.jar

Does anybody can help me with it ?

[Yevhen Nahornyi · Accepted solution]

Found solution here https://confluence.atlassian.com/confkb/install-upgrade-confluence-7-11+-fails-with-error-you-do-not-have-the-super-privilege-and-binary-logging-is-enabled-1044096915.html