Mysql1418 solution to function creation failure bitsCN.com
How to create a function in mysql 1418
ErrorCode: 1418
ThisfunctionhasnoneofDETERMINISTIC, NOSQL, orREADSSQLDATAinitsdeclarationandbinaryloggingisenabled (you * might * wanttousethelesssafelog_bin_trust_function_creatorsvariable)
(0 mstaken)
The solution is as follows:
1. mysql> set global log_bin_trust_function_creators = 1;
2. when the system is started -- log-bin-trust-function-creators = 1
3. add a line of log-bin-trust-function-after marking [mysqld] in the my. ini (my. conf in linux) file-
Creators
If there is a 1418 error in the create function: you only need to execute set global log_bin _
Trust_routine_creators = 1;
Then there will be no problem with how to create a function (of course, your function must be correct). This is a bug in mysql,
I don't know why. it's okay to do this anyway.
In addition, you can add the following line [mysqld] log_bin_trust_routine_creators = 1 in the configuration file my. cnf;
This command can be run in the SQL editor environment without restarting the service.
BitsCN.com