Page 1 of 1

Mariadb local_infile security risk

Posted: 2018/11/23 11:57:05
by shahar91
Hi, I learning MariaDB and his security issues.
What is the purpose of "load data local" (local_infile)? In which cases I need this option and when can I disable it.
Its only use for export and import information between text file and table?

Thanks

Re: Mariadb local_infile security risk

Posted: 2018/11/29 18:18:31
by aks
"What is the purpose of "load data local" (local_infile)?"
Translate as "load a bunch of SQL statements for execution".

"In which cases I need this option and when can I disable it."
Disable it until you need it (look into session versus global variables, althought I think it;'s global anyway, but it'll help your understanding).

Re: Mariadb local_infile security risk

Posted: 2018/12/05 00:06:12
by shahar91
aks wrote:
2018/11/29 18:18:31
"What is the purpose of "load data local" (local_infile)?"
Translate as "load a bunch of SQL statements for execution".

"In which cases I need this option and when can I disable it."
Disable it until you need it (look into session versus global variables, althought I think it;'s global anyway, but it'll help your understanding).
Thanks :)