在安装MySQLServer的最后一步(应用配置)期间,我遇到了一个奇怪的错误。我搞不懂。这是日志:
Beginning configuration step: Initializing database (may take a long time)
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.31...
Starting process with command: C:\Program Files\MySQL\MySQL S
是否可以使用MySql工作台中的本地-内部文件选项进行连接?如下所示:
mysql -h 10.152.xx.xx -u USER -p --local-infile MyDatabase
原因是,LOAD DATA LOCAL INFILE似乎只适用于此选项。即使
SHOW GLOBAL VARIABLES LIKE 'local_infile';
返回
'local_infile', 'ON'
LOAD DATA LOCAL INFILE收益率
Error Code: 1148. The used command is not allowe