Geek asks and answers

Disabling LOCAL INFILE in MariaDB

The MySQL security article recommends disabling LOCAL INFILE if I don't need it. http://www.greensql.com/content/mysql-security-best-practices-hardening-mysql-tips

I would like to do the same in MariaDB, but the following configuration line does not work in MariaDB (used to work in Mysql):

set-variable=local-infile=0

Does anyone know how to disable it? Or maybe it doesn’t have a runtime configuration configurator and needs to be compiled using a special configure flag?

+3
source share
1 answer

The method for setting variables was deprecated in MySQL 5 , and instead you can set the variable by name directly to my.cnf.

MariaDB 5.5.34:

[mysqld]
local-infile=0

MariaDB my.cnf

variable-name = "value"
+7

More articles:


All Articles