Mysql使用load命令报错

问题1:

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

需要在my.cnf文件里面添加

[mysqld]
secure_file_priv=''

问题2:

ERROR 13 (HY000): Can't get stat of '/root/20220817.csv' (Errcode: 13 - Permission denied)

　　

　　

　　

posted @ 2022-10-13 20:46  lucky_tomato  阅读(52)  评论(0)  编辑  收藏  举报