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%';