ERROR 1418 (HY000) at line 15089

This error started to show up this morning when restoring a backup. This error did not occur on the last run through of restoring a backup (3 weeks ago).

• 10:33:26 AM : ERROR: Job execution error: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1418 (HY000) at line 15089: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable) Server name: “MYSERVER”
• 10:33:28 AM : ERROR: Job “RESTORE - TR to LOCAL” finished with “1” errors

From a stackoverflow suggestion we added log_bin_trust_function_creators = 1; to my.ini but it did not help.

Hello Steve_Logan,

Thank you for the details.

It seems this issue related to MySQL Server. Could you please try to perform a backup/restore manually via mysqldump to check if it works.

You can find more details on how to do it on the web.

Sorry for the inconvenience.