Mac 环境下mysql导入数据提示LOAD DATA LOCAL INFILE file request rejected due to restrictions on access，如何解决呢

Mac 环境下mysql导入数据提示LOAD DATA LOCAL INFILE file request rejected due to restrictions on access。
如果加local-infile 输入密码时一直提示错误

这有个mac的解决方法，希望对你有帮助：

img


mysql - ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access - Stack Overflow https://stackoverflow.com/questions/63361962/error-2068-hy000-load-data-local-infile-file-request-rejected-due-to-restrict

在导入的时候，加上–local-infile=1
MySQL 8.0版本， local_infile默认是关闭的，但是MySQL 5.7版本默认是开启的；