1
CREATE TABLE t1 (c1 longtext);
2
INSERT INTO t1 values ('a');
3
SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR/B11764517.tmp';
4
show global variables like 'secure_file_priv';
6
secure_file_priv MYSQL_TMP_DIR/
7
SELECT load_file('MYSQL_TMP_DIR\\B11764517.tmp') AS x;
11
SELECT load_file('MYSQL_TMP_DIR/B11764517.tmp') AS x;
15
SELECT load_file('MYSQL_TMP_DIR_UCASE/B11764517.tmp') AS x;
19
SELECT load_file('MYSQL_TMP_DIR_LCASE/B11764517.tmp') AS x;
23
SELECT load_file('MYSQL_TMP_DIR\\..a..\\..\\..\\B11764517.tmp') AS x;
26
LOAD DATA INFILE 'MYSQL_TMP_DIR\\B11764517.tmp' INTO TABLE t1;
27
LOAD DATA INFILE 'MYSQL_TMP_DIR/B11764517.tmp' INTO TABLE t1;
28
LOAD DATA INFILE 'MYSQL_TMP_DIR_UCASE/B11764517.tmp' INTO TABLE t1;
29
LOAD DATA INFILE 'MYSQL_TMP_DIR_LCASE/B11764517.tmp' INTO TABLE t1;
30
LOAD DATA INFILE "MYSQL_TMP_DIR\\..a..\\..\\..\\B11764517.tmp" into table t1;
31
ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
32
SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR\\..a..\\..\\..\\B11764517-2.tmp';
33
ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
34
SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR\\B11764517-2.tmp';
35
SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR/B11764517-3.tmp';
36
SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR_UCASE/B11764517-4.tmp';
37
SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR_LCASE/B11764517-5.tmp';