mysql 还原数据库 you *might* want to use the less safe log_bin_trust_function_creators variable

C:\WINDOWS\system32>D:\SOFTWARE\mysql-5.7.33-winx64\bin\mysql --port=7506 -uroot --password=pwd < D:\SOFTWARE\mysql-5.7.33-winx64\20220910bak\20220910.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1418 (HY000) at line 1185: 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)

 

解决方法：

SET GLOBAL log_bin_trust_function_creators = 1;