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-2020, Ispirer Systems Ltd. All Rights Reserved. Privacy Statement |