Web lists-archives.com

Re: command is not allowed with this MySQL version

>>>> 2014/12/12 02:10 +0100, Christophe >>>>
When the app tries to do this, it raises an error :

'The used command is not allowed with this MySQL version'

The used MySQL version is 5.5.40 from Debian Wheezy package.

I found that some parameters or variables (local_infile for instance) can be used to get rid of this error, but can't really find the right configuration. 
Well, yes, if local_infile is 0 or FALSE then 'LOCAL' is forbidden. If 'LOCAL' is not used then the MySQL user needs privilege 'FILE' to read from the server s own disk.
What else have you tryed, with what outcome? because the statement as it stands is good MySQL.

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql