본문 바로가기
반응형

분류 전체보기209

ERROR 1418 (HY000) at line 244: 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) mysql -u root -p testdb 2022. 5. 26.
tcpdump # tcpdump -n -i eth0 tcp port 8000 # tcpdump -i eth0 -n -l -s0 -A tcp port 8000 2022. 4. 30.
[Linux] CentOS 8: Failed to download metadata for repo 'appstream' [root@g15 ~]# yum list Failed to set locale, defaulting to C.UTF-8 CentOS-8 - AppStream 36 B/s | 38 B 00:01 Failed to download metadata for repo 'AppStream' Error: Failed to download metadata for repo 'AppStream' [root@g15 yum.repos.d]# ls CentOS-AppStream.repo CentOS-Debuginfo.repo CentOS-Media.repo CentOS-Vault.repo CentOS-Base.repo CentOS-Extras.repo CentOS-PowerTools.repo CentOS-centosplus.r.. 2022. 4. 23.
MYSQL 함수 생성시 ERROR 1418 (HY000): 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) 에러 해결. MySQL 에서 함수를 만들려고 하는데 CREATE FUNCTION 문을 선언하니 ERROR 1418 (HY000) : This function hasn 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) 이런 에러가 뜨면서 함수가 생성되지 않았습니다. 구글링을 하니 간단하게 해결 방법이 있었습니다. http://www.mysqlkorea.com/gnuboard4/bbs/board.php?bo_table=community_03&wr_id=1.. 2022. 4. 9.
반응형