ERROR 1419 (HY000) at line 1918 오류 조치 방법

-->mariadb import 실행시 오류 발생

[root@test ~]# mysql -uroot -p < test_20221005.sql
ERROR 1419 (HY000) at line 1918: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

-->mariadb 접속 후 log_bin_trust_function_creators 확인

[root@test ~]# mysql -uroot -p

MariaDB [(none)]> show variables like '%log_bin_tr%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------+
1 row in set (0.037 sec)

-->log_bin_trust_function_creators 활성화
MariaDB [(none)]> set global log_bin_trust_function_creators=1;