Mengatasi Error DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
Jika di mysql mendapatkan error seperti dibawah ini:
1418 (HY000) at line 10185: 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)
dapat diselesaikan dengan cara:
1. jalan kan di cmd/terminal: SET GLOBAL log_bin_trust_function_creators = 1;
2. Masukan di konfgurasi my.cnf : log_bin_trust_function_creators = 1;
1418 (HY000) at line 10185: 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)
dapat diselesaikan dengan cara:
1. jalan kan di cmd/terminal: SET GLOBAL log_bin_trust_function_creators = 1;
2. Masukan di konfgurasi my.cnf : log_bin_trust_function_creators = 1;
Komentar
Posting Komentar