According to https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_local_infile this variable has GLOBAL scope (and I don-t think mariaDB has changed anything here. The SESSION-scope value is always inherited from the GLOBAL setting.

'local-infile' is also considered a security setting and as such it makes sense IMO that a user cannot change for his SESSION as she likes.

Also I get this (on Windows)

C:\Program Files\MariaDB 10.2\bin>mysql -u root -p local-infile=1

Enter password: ********

ERROR 1049 (42000): Unknown database 'local-infile=1'

Is it possible to specify a server variable on the commandline at all? I don't think so. At least I never heard about it.

-- Peter

-- Webyog

On Wed, Feb 15, 2017 at 2:43 PM, Karthick Subramanian <ksubramanian@paycommerce.com> wrote:

HI All,

Even after enabling --local-infile=1 at mysql user login, I couldn't load the file locally.

mysql -u root --local-infile=1

LOAD DATA LOCAL INFILE

ERROR 1148 (42000): The used command is not allowed with this MariaDB version

show variables like '%local%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+

Even though i enable --local-infile=1, the local-infile still shows OFF.

Pleaselet know how can I fix this.

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp