Load Data Infile in Windows

from the Artful MySQL Tips List


In recent versions, MySQL runs in Windows as a user name "Network Service". To run Load Data Infile on an input file in c:\in, Network Service needs privileges in that folder:

1. In Windows Explorer, navigate to c:\in, right-click, and select the Security tab.

2. If Network Service is in the Groups or User Names list, click on it to ensure it has Read/Write permissions. If not, click on Edit, then Add, enter "Network Service" as the object name, click on OK, and check permissions as above.

If you are seeing the error "The used command is not allowed with this MYSQL version", see ...

https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-file-priv-in-mysql

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv



Return to the Artful MySQL Tips page