If MySQL fails to create a function, is there any solution? Of course. The following describes how to easily solve the problem that functions cannot be created in MySQL.
Analysis of MySQL function creation problems:
According to the system prompt, the cause of this error may be a security configuration. The log_bin_trust_function_creators parameter in the manual is 0 by default, and function synchronization is not allowed.
Generally, when configuring repliaction, we forget to pay attention to this parameter. In this way, after the master updates the funtion, slave reports an error and slave stoped.
MySQL function creation process:
Log on to the mysql database
> Set global log_bin_trust_function_creators = 1;
> Start slave;
Tracking mysql startup logs. slave runs normally and the problem is solved.
Continuous tracking. After one night, all bin-relay-log data is synchronized. Add it directly in my. cnf
Log_bin_trust_function_creators = 1
In this way, it will be automatically enabled after restart.
Connection between MySQL stored procedures and databases
Take you to understand mysql Variables
MySQL user permission setting method
How to implement a dynamic MySQL View
How to process MySQL record duplication