在MySql Workbench中使用local-infile选项连接 [英] Connect with local-infile Option in MySql Workbench

问题描述

是否可以与MySql Workbench中的local-infile Option连接?像这样:

Is it possible to connect with the local-infile Option in MySql Workbench? Like this:

mysql -h 10.152.xx.xx -u USER -p --local-infile MyDatabase

原因是，LOAD DATA LOCAL INFILE似乎仅与此选项一起使用.即使

The reason is, that LOAD DATA LOCAL INFILE seems to work only with this option. Even if

SHOW GLOBAL VARIABLES LIKE 'local_infile'; 

返回

'local_infile', 'ON'

LOAD DATA LOCAL INFILE产量

LOAD DATA LOCAL INFILE yields

Error Code: 1148. The used command is not allowed with this MySQL version

推荐答案

在MySQL Workbench中编辑连接设置.

Edit the connection settings in MySQL Workbench.

在高级"选项卡下，将以下选项添加到其他窗口的连接器选项中:

Under the Advanced tab, add the following option to the connector options in the others window:

OPT_LOCAL_INFILE = 1

OPT_LOCAL_INFILE=1

这篇关于在MySql Workbench中使用local-infile选项连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！