解决——》ERROR 3948 (42000)Loading local data is disabled； this must be enabled

水深无声 2024-03-31 16:20 94阅读 0赞

> 推荐链接：  
> [总结——》【Java】][Java]  
> [总结——》【Mysql】][Mysql]  
> [总结——》【Redis】][Redis]  
> [总结——》【Kafka】][Kafka]  
> [总结——》【Spring】][Spring]  
> [总结——》【SpringBoot】][SpringBoot]  
> [总结——》【MyBatis、MyBatis-Plus】][MyBatis_MyBatis-Plus]

@\[TOC\](解决——》ERROR 3948 (42000)Loading local data is disabled; this must be enabled on both the client and server sides)

## 1、操作 ##

`load data local infile "c:/Users/xiaox/Desktop/test.txt" into table test (id,area);`

## 2、现象 ##

`ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides`

## 3、原因 ##

需要在进入数据库时，加下–local\_infile参数

## 4、解决 ##

`mysql -h localhost -u root -p xiaoxian --local-infile`  
`load data local infile "c:/Users/xiaox/Desktop/test.txt" into table test (id,area);`

[Java]: https://blog.csdn.net/weixin_43453386/article/details/84788317
[Mysql]: https://blog.csdn.net/weixin_43453386/article/details/88667709
[Redis]: https://blog.csdn.net/weixin_43453386/article/details/127966762
[Kafka]: https://blog.csdn.net/weixin_43453386/article/details/128189472
[Spring]: https://blog.csdn.net/weixin_43453386/article/details/124900806
[SpringBoot]: https://blog.csdn.net/weixin_43453386/article/details/84788714
[MyBatis_MyBatis-Plus]: https://blog.csdn.net/weixin_43453386/article/details/84788053