How to enable, disable, and view functions of MySQL database _ MySQL

This article mainly introduces how to enable, disable, and view functions of MySQL databases. This article summarizes the solution to an error and provides the error information, if you want to create a function, you may encounter a problem when you use MySQL. The following error message is displayed:

The code is as follows:

ERROR 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)

This is because the function is not enabled.

Enable the MySQL function:

The code is as follows:

Set global log_bin_trust_function_creators = 1;

Disable the MySQL function:

The code is as follows:

Set global log_bin_trust_function_creators = 0;

View Status:

The code is as follows:

Show variables like '% func % ';