This shows you the differences between two versions of the page.
sqlways:troubleshooting-guide:mysql:import:command-not-allowed-data-load [April 26, 2019, 12:28:24 PM] darya.prikhodkina [Solutions] |
sqlways:troubleshooting-guide:mysql:import:command-not-allowed-data-load [July 25, 2019, 08:12:59 AM] (current) alexandr.kirpichny |
||
---|---|---|---|
Line 36: | Line 36: | ||
Both client and server should enable the local-file option. Otherwise it will not work. To enable it for files on the server side, add the following to the my.cnf configuration file: | Both client and server should enable the local-file option. Otherwise it will not work. To enable it for files on the server side, add the following to the my.cnf configuration file: | ||
- | loose-local-infile = 1 | + | |
+ | loose-local-infile = 1 | ||
+ | |||
+ | Or if you have SUPER privileges, you can execute the following command on the server: | ||
+ | |||
+ | SET GLOBAL local_infile = 1; | ||
More information about "loose-local-infile" option can be found here: __**[[https://dev.mysql.com/doc/refman/8.0/en/load-data-local.html|Security Issues with LOAD DATA LOCAL]]**__ | More information about "loose-local-infile" option can be found here: __**[[https://dev.mysql.com/doc/refman/8.0/en/load-data-local.html|Security Issues with LOAD DATA LOCAL]]**__ |
© 1999-2019, Ispirer Systems Ltd. All Rights Reserved. Privacy Statement |