I am having an issue that is replicated in a live and test environment where if I run 'Build Cache' option from the Admin Settings tab I get this error :
The 'Workflow Applications Cache Info' details shows current/root user not having SUPERUSER/SUPER Privileged (Highlighted in yellow) :
Another live site running on an older Processmaker and MySQL version that does not have this issue shows this :
I took a look at the log and the error generates this message :
ExceptionCron ERROR: Could not execute query [Native Error: 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)]
Is it safe to make this change to log_bin_trust_function_creators or is there another solution?
Any help would be appreciated.