08CMS Info: MySQL Query Error
Time: 2017-11-4 11:56
SQL: LOAD DATA INFILE 'E:/project/09cms/install/sql/load_files/' INTO TABLE #__abrels
CHARACTER SET utf8
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''''
LINES TERMINATED BY '
'
File: run() called at [/install/index.php : 20]
Error: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Errno.: 1290
08CMS信息:MySQL查询错误
时间:2017-11-4 11:56
SQL:LOAD DATA INFILE’E:/project/09cms/install/sql/load_files/INTO TABLE #__abrels
字符集utf8
FIELDS TERMINATED BY’,’
任选地由“’”
线路终止“
“
文件:run()在[/install/index.php:20]处调用
错误:MySQL服务器正在运行–secure-file-priv选项,所以它不能执行这个语句
Errno:1290
1、我们也可以通过命令查看secure-file-priv的当前值:
show variables like '%secure%';
如上图所示,我设置的secure-file-priv值为NULL,而 MySQL 默认的值为:
secure-file-priv=”E:/project/09cms/install/sql/load_files/”
2、我们可以通过打开my.ini配置文件进行查看及修改:
secure-file-priv="E:/project/09cms/install/sql/load_files/"
3、重启服务器 ,再次查看
show variables like '%secure%';