The Repository

Today I was struggling while creating a funtion on mysql database. It can be executed with the root privilageds but shows an error massage when it is executed with low privilages. The error massage is shown bellow.

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

>>To avoid this error you must do one of the following.

1. Specify the one or more of DETERMINISTIC, NO SQL, and/or READS SQL DATA key words in your stored function definition.
2. Set the value of "log_bin_trust_function_creators" to '1',
   (mysql> SET GLOBAL log_bin_trust_function_creators = 1;)

You can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.

>>The current conditions on the use of stored functions in MySQL 5.0 can be summarized as follows. These conditions do not apply to stored procedures and they do not apply unless binary logging is enabled.

1. To create or alter a stored function, you must have the SUPER privilege, in addition to the CREATE ROUTINE or ALTER ROUTINE privilege that is normally required.
2. When you create a stored function, you must declare either that it is deterministic or that it does not modify data. Otherwise, it may be unsafe for data recovery or replication.

>>For more information refer this article "Binary Logging of Stored Programs".