【Mysql】1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration

 问题描述

[Msg] Decompressing...
[Msg] 1418 - 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)
[Msg] Importing Data...
[Msg] Rolling back...
[Msg] Finished - Stopped before completion
--------------------------------------------------

解决方案

在还原备份前，先将备份的函数属性修改正确，如：

选中报错函数，设计函数->高级->数据访问，选中合适的数据库访问安全级别

• NO SQL                       -  包含SQL语句
• CONTAINAS SQL        -  无SQL语句
• READS SQL DATA      -  SQL语句读取数据
• MODIFIES SQL DATA -  SQL语句修改数据