mysql 导出数据到文件数据异常 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
首先输入下面下面命令查看
show global variables like '%secure%';

查询secure_file_priv 我的当时为null所以要修改:

修改方法:

浙公网安备 33010602011771号