maria-discuss team mailing list archive
Mailing list archive
Re: LOAD DATA 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
'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.
On Wed, Feb 15, 2017 at 2:43 PM, Karthick Subramanian <
> 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
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp