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.