错误如下:
Error Code: 3948. Loading local data is disabled; this must be enabled on both the client and server sides
加载文件时,显示“错误代码:3948。已禁用加载本地数据;这必须在客户端和服务器端都启用”
解决办法:
输入命令:SHOW VARIABLES LIKE 'local_infile';查看权限
此时的权限未打开,Value值应为OFF,接着输入命令:SET GLOBAL local_infile = 1;
此时的权限已经打开,Value值应为ON,3948问题解决!