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 < ksubraman...@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 > >
_______________________________________________ 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
