Question

mysql 1290 怎么解决

Answer 1

mysql 插入数据时Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 0.00023 sec

解决：
show variables like '%secure_file_priv%';
然后把要导入的数据文件放到该文件夹。我这里是/var/lib/mysql-files/