Mysql使用load命令报错

问题1:

?

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

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

?

1 2	[mysqld] secure_file_priv=''

问题2:

?

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