运行Load data local infile命令时：
mysql> LOAD DATA LOCAL INFILE '/path/file' INTO TABLE tablename;- 1
出现：
ERROR 1148 (42000): The used command is not allowed with this MySQL version- 1
这是因为：
服务器端，local_infile默认开启；客户端，local_infile默认关闭，因此用的时候需要打开。
On the server side:
The local_infile system variable controls server-side LOCAL capability. Depending on the local_infile setting, the server refuses or permits local data loading by clients that have LOCAL enabled on the client side. By default, local_infile is enabled.
On the client side:
For the mysql client, local data loading is disabled by default. To disable or enable it explicitly, use the –local-infile=0 or –local-infile[=1] option.
该怎么办呢？
可以：
mysql> show global varaiables like 'local_infile';- 1
出现：
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set (0.00 sec)- 1
- 2
- 3
- 4
- 5
- 6
可以这么做：
mysql> set global local_infile = 'ON';- 1
local_infile其实是bool变量，但这里用ON。
然后可以看到：
mysql> show global varaiables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
1 row in set (0.00 sec)- 1
- 2
- 3
- 4
- 5
- 6
- 7
然后再试试Load data，本人仍旧出错还是：
ERROR 1148 (42000): The used command is not allowed with this MySQL version- 1
因而退出mysql，执行quit或exit，然后用如下命令登录mysql：
$ mysql --local-infile=1 -u root -p- 1
然后就可以顺利Load data infile了。
https://dev.mysql.com/doc/refman/5.7/en/load-data-local.html
