Who can guide the problem that MySQL cannot import local files? Feedback: no authority

CSDN Q & A 2022-05-15 04:41:40 阅读数:762

guideproblemmysqlimportlocal

Today's study is in MySQL 8.0 Command Line Client On the use of SQL Command to load local disk file , But it didn't work . It can ensure that the code entered is correct .

Page shows “ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.”

img

Search solutions , All are “ -u --local-infile=1 -p” such , But I don't know where to enter these codes , I don't know what the input format should be , Try many times , They all failed

Tried for most of the day , Really desperate , Who can guide me? What's the reason ? Thank you




Take the answer :

Go to CMD Log in from mysql Execute Import command , mysql Of client The local disk cannot be read


版权声明:本文为[CSDN Q & A]所创,转载请带上原文链接,感谢。 https://primo.wiki/2022/131/202205041916555220.html