Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases

Whether log_bin_trust_function_creators is set to on in both the source and destination databases

During the out-of-cloud migration from MySQL to MySQL, the log_bin_trust_function_creators value of the source database must be the same as that of the destination database. If the source database supports user-defined functions (UDFs) but the destination database does not, change the log_bin_trust_function_creators=off parameter of the destination database to log_bin_trust_function_creators=on. If the parameters of the source and destination are different, the migration may fail.

Item to be confirmed: The destination database does not support custom functions.

Handling suggestions: In the my.cnf file of the destination database, check whether log_bin_trust_function_creators=on exists. If it does not exist, add log_bin_trust_function_creators=on and restart the database for the modification to take effect.