Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database
Updated on 2024-11-30 GMT+08:00

Checking Whether log_bin_trust_function_creators Is Set to On in the Destination Database

During the migration from RDS for MySQL to MySQL out of the cloud, the destination database does not support user-defined functions.

Item to Be Confirmed

The destination database does not support user-defined functions.

Handling Suggestion

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.