MySQL File Security Testing

mysql_file_security_testing.sql

select @@secure_file_priv;
select @@local_infile;

CREATE TABLE load_data_local_infile (
file_id int unsigned not null auto_increment primary key,
content text not null
);
CREATE TABLE load_file (
file_id int unsigned not null auto_increment primary key,
file_name varchar(255) not null,
content text not null
);

-- load file from the system the mysql client is running from
LOAD DATA LOCAL INFILE '/etc/my.cnf'
    IGNORE
    INTO TABLE `test`.`load_data_local_infile`
    CHARACTER SET utf8
    FIELDS
        TERMINATED BY '\n'
        OPTIONALLY ENCLOSED BY '"'
    IGNORE 1 LINES
    (content)
;

-- load file from mysql host
INSERT INTO load_file values (
NULL,
'/etc/my.cnf',
LOAD_FILE('/etc/my.cnf')
);