windows下MySQL8中LOAD DATA INFILE出现The used command is not allowed with this MySQL version问题

环境：
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.13    |
+-----------+

运行Load data local infile命令时：

mysql> LOAD DATA LOCAL INFILE 'D:/XXX.txt' INTO TABLE tablename;

出现：

ERROR 1148 (42000): The used command is not allowed with this MySQL version

这是因为：
服务器端，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 variables like 'local_infile';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | OFF    |
+---------------+-------+
1 row in set (0.00 sec)

然后再试试Load data，本人仍旧出错还是：

ERROR 1148 (42000): The used command is not allowed with this MySQL version

因而退出mysql，执行quit或exit，然后用如下命令登录mysql：

$ mysql --local-infile=1 -u root -p

然后就可以顺利Load data infile了。