| 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 |
#----------------------------------------------------------------------- |