解决——》ERROR 2068 (HY000) LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.

本是古典何须时尚 2024-03-31 16:20 45阅读 0赞

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

@\[TOC\](解决——》ERROR 2068 (HY000) LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.)

## 1、操作 ##

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

## 2、现象 ##

`ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.`

## 3、原因 ##

未启用local\_infile

## 4、解决 ##

启动local\_infile

[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