admin管理员组文章数量:1640597
问题描述:
日志写入数据时报错
Loading local data is disabled; this must be enabled on both the client and server sides
排查原因:
属于mysql导入数据报错:local_infile服务器变量指示能否使用load data local infile命令。该变量为OFF时,禁用客户端的load data local infile命令,该变量默认为ON, 报错消失。
1、查看local_infile变量状态为ON or OFF
登录mysql:
cmd:mysql -u root -p
查看变量:show global variables like 'local_infile';
mysql> show global variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set, 1 warning (0.01 sec)
解决办法:修改mysql配置文件
windows为my.ini (Linux为myf】)
在my.ini 或myf文件中做如下修改:
[mysqld]下添加
local_infile = 1
[mysql]下添加
local_infile = 1
mysql服务重启:
cmd:net stop mysql
net start mysql
查看local_infile变量状态:
mysql> show global variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
1 row in set, 1 warning (0.01 sec)
local_infile变量状态为ON,日志写入不再报错。
本文标签: 解决方案DatadisabledloadingLocal
版权声明:本文标题:Loading local data is disabled; this must be enabled on both the client and server sides解决方案 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/xitong/1729318537a1195595.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论