#----------------------------------------------------------------------- # Setup #----------------------------------------------------------------------- # Search for : --secure-file-priv is set to NULL. Operations # related to importing and exporting data are # disabled show variables like 'secure_file_priv'; Variable_name Value secure_file_priv null use test; drop table if exists secure_file_priv_test_null; create table secure_file_priv_test_null(c1 int); insert into secure_file_priv_test_null values (1), (2), (3), (4); select * from secure_file_priv_test_null into outfile 'blah'; ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement select * from secure_file_priv_test_null into outfile 'null/blah'; ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement drop table secure_file_priv_test_null; #----------------------------------------------------------------------- # Clean-up #-----------------------------------------------------------------------
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
access_credential_control.result | File | 30.47 KB | 0644 |
|
cert_verify.result | File | 304 B | 0644 |
|
have_mysql_upgrade.result | File | 21 B | 0644 |
|
have_ssl.require | File | 33 B | 0644 |
|
key_value_auth.result | File | 21.85 KB | 0644 |
|
mysql_native_plugin.result | File | 11.18 KB | 0644 |
|
mysql_no_login.result | File | 1.75 KB | 0644 |
|
mysql_old_passwords.result | File | 19.09 KB | 0644 |
|
mysql_old_plugin.result | File | 15.43 KB | 0644 |
|
mysql_sha256_plugin.result | File | 11.1 KB | 0644 |
|
not_embedded.require | File | 16 B | 0644 |
|
not_openssl.require | File | 36 B | 0644 |
|
not_ssl.require | File | 32 B | 0644 |
|
openssl.require | File | 37 B | 0644 |
|
password_expired.result | File | 27.84 KB | 0644 |
|
secure_file_priv_error.result | File | 358 B | 0644 |
|
secure_file_priv_null.result | File | 1.08 KB | 0644 |
|
secure_file_priv_warnings.result | File | 876 B | 0644 |
|
secure_file_priv_warnings_not_win.result | File | 582 B | 0644 |
|
secure_file_priv_warnings_win.result | File | 454 B | 0644 |
|
server_withssl_client_withoutssl.result | File | 14.53 KB | 0644 |
|
server_withssl_client_withssl.result | File | 14.33 KB | 0644 |
|