How to turn on, off, and view function functions of Mysql database _mysql

When you apply MySQL, you will encounter situations where you cannot create a function. The following error message appears:

Copy Code code as follows:

ERROR 1418:this function has none of deterministic, NO SQL, or reads SQL DATA in its declaration and binary the IS E Nabled (for your *might* want to use the less safe log_bin_trust_function_creators variable)

That is because the function is not turned on.

Open MySQL function function:

Copy Code code as follows:

SET GLOBAL Log_bin_trust_function_creators=1;

Turn off MySQL function function:

Copy Code code as follows:

SET GLOBAL log_bin_trust_function_creators=0;

View Status:

Copy Code code as follows:

Show variables like '%func% ';