728x90

목록The MySQL server is running with the --secure-file-priv (1)

뭐든 즐기면서 ;)

MySQL The MySQL server is running with the --secure-file-priv

Error 내용 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 해결 방법 1. select @@GLOBAL.secure_file_priv; 로 확인된 경로에 파일을 만들어준다. mysql> select @@GLOBAL.secure_file_priv; +---------------------------+ | @@GLOBAL.secure_file_priv | +---------------------------+ | /var/lib/mysql-files/ | +---------------------------+ 1 row in set (0.00 ..
Error 2023. 5. 13. 02:00
728x90
Prev 1 Next