mysql使用文件导入数据是报错：
Loading local data is disabled; this must be enabled on both the client and server sides
临时解决办法：
命令行输入mysql登录命令：
mysql --local-infile=1 -u root -p
设置变量：SET GLOBAL local_infile=1;
查看变量：show global variables like ‘local_infile‘;
mysql> show global variables like ‘local_infile‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
1 row in set (0.00 sec)
导入文件没有问题，但是重启mysql服务，依然会提示以上错误
永久解决办法：就是在mysql服务启动时自动加载该配置，修改mysql配置文件
mysqld.cnf中的
[mysqld]
下添加
local_infile = 1
mysql.cnf中的
[mysql]
下添加
local_infile = 1
mysql服务重启
service mysql restart
命令行查看local_infile变量状态
mysql> SHOW GLOBAL VARIABLES LIKE ‘local_infile‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
1 row in set (0.00 sec)
说明配置成功
导入文件正常
local_infile服务器变量指示能否使用load data local infile命令。该变量默认为ON。
该变量为OFF时，禁用客户端的load data local infile命令。
Loading local data is disabled; this must be enabled on both the client and server sides
原文：https://www.cnblogs.com/leinuo2016/p/15180560.html