Mariadb local_infile security risk

Support for security such as Firewalls and securing linux
Post Reply
shahar91
Posts: 7
Joined: 2018/03/26 19:01:30

Mariadb local_infile security risk

Post by shahar91 » 2018/11/23 11:57:05

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

aks
Posts: 3073
Joined: 2014/09/20 11:22:14

Re: Mariadb local_infile security risk

Post by aks » 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).

shahar91
Posts: 7
Joined: 2018/03/26 19:01:30

Re: Mariadb local_infile security risk

Post by shahar91 » 2018/12/05 00:06:12

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 :)

Post Reply