오류
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)
해결방법
SET GLOBAL log_bin_trust_function_creators = 1;
예시
SET GLOBAL log_bin_trust_function_creators = 1; 입력
후 dump file import start
'Backend > DB' 카테고리의 다른 글
| [MySQL] Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 해결법 (0) | 2020.08.20 |
|---|---|
| [Mysql] 설치 및 dump file import 까지 (0) | 2020.08.20 |
| [MySql] 자연어 검색 플러그인 Mecab (FullText, 한글 검색 ...) (0) | 2020.08.19 |
| [MySql] FullText 설정 관련 블로그 (0) | 2020.08.18 |
| [MYSQL] grant all on *.* to 'root'@'%' identified by 'password' with grant option; 실행 시 ERROR 1064 (42000) 오류 해결 (0) | 2020.07.07 |
