Debian Codegraph @

mysql-test/suite/auth_sec/r/secure_file_priv_null.result

raw
1 #-----------------------------------------------------------------------
2 # Setup
3 #-----------------------------------------------------------------------
4 # Search for : --secure-file-priv is set to NULL. Operations
5 # related to importing and exporting data are
6 # disabled
7 Pattern "--secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled" found
8 show variables like 'secure_file_priv';
9 Variable_name Value
10 secure_file_priv null
11 use test;
12 drop table if exists secure_file_priv_test_null;
13 create table secure_file_priv_test_null(c1 int);
14 insert into secure_file_priv_test_null values (1), (2), (3), (4);
15 select * from secure_file_priv_test_null into outfile 'blah';
16 ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
17 select * from secure_file_priv_test_null into outfile 'null/blah';
18 ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
19 drop table secure_file_priv_test_null;
20 #-----------------------------------------------------------------------
21 # Clean-up
22 #-----------------------------------------------------------------------