Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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]]**__
sqlways/troubleshooting-guide/mysql/import/command-not-allowed-data-load.txt · Last modified: July 25, 2019, 08:12:59 AM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement