Skip to main content

Posts

Showing posts from June, 2021

The used command is not allowed with this MySQL version

The reason can be the server variable 'local_infile' is set to FALSE or 0. We can verify by executing:  SHOW VARIABLES LIKE 'local_infile' ; If you have the privilege, we can enable it by using  SET GLOBAL  local_infile = 1; Another option is to change the config in my.cnf file [client] loose-local-infile=1 We have an another option by changing the MySQL connector string by adding the parameter allowedLoadLocalInfile=true Eg:- jdbc:mysql//<IP>:<PORT>/<DB>?allowLoadLocalInfile=true&useSSL=false