ZABBIX 6.0.11以上へアップグレードするとzabbix_serverが起動しない場合の対処方法

sudo tail -f /var/log/zabbix/zabbix_server.log

# 確認すると次のようなログが繰り返し表示されていて、バイナリーログに関する権限がなさそう。
current database version (mandatory/optional): 06000000/06000010
required mandatory version: 06000000
optional patches were found
starting automatic database upgrade
[Z3005] query failed: [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) [create trigger hosts_name_upper_insert
before insert on hosts for each row
set new.name_upper=upper(new.name)]

mysql> SET GLOBAL log_bin_trust_function_creators = 1;

mysql> SET GLOBAL log_bin_trust_function_creators = 0;