MySQL server is running with the –secure-file-priv

[DanielHDUrso]

Thanks. Very clear explanation of what is going on and what to do about it.

[Gett]

Didn't have ProgramData\MySQL folder. Here's what else you can do:
SET GLOBAL local_infile=1; (to allow LOCAL keyword on server)
mysql -u root -pqwerty --local-infile=1 (relogin with allowed LOCAL)
Now you can import data files as usually, just add LOCAL keyword to your LOAD DATA statement like that:
LOAD DATA LOCAL INFILE ...
After you're done you can turn global variable back to it's default:
SET GLOBAL local_infile=0;

[captainchannel]

Thank you so much bro. You have saved my hours.

[rohitjadhav]

Thank You so much brother !! God bless ❤

[floinconnu]

Hello,
From which terminal you executed commands…in which folder you find it?

[vineelsai]

is it one time change ois enough or everytime we export data from sql to excel shouls we have to change everytime

[ManishSingh-yhbm]

Thanks bro…..now it’s working fine…..👍🏻👍🏻👍🏻…..

[mohammedrafi]

bro i hav store a image in my database but im unable get access to the folder what to do im struggling here with some project help me out

[manishkumarhate]

its really helpful, but my table is not coming in proper format... many thing is missing

[sanaa_kasim]

OMG THANK YOU SO MUCH MAN YOU SAVED ME

[nakulbarot]

after doing these --"cannot connect to database server?"

[amaanmohammed]

when I enter the command it only shows that it is an empty set!

[jaychopra]

finally i found the solution'' thankss budddy