1
select @@global.secure_file_priv;
2
@@global.secure_file_priv
4
select @@session.secure_file_priv;
5
ERROR HY000: Variable 'secure_file_priv' is a GLOBAL variable
6
show global variables like 'secure_file_priv';
8
secure_file_priv MYSQLTEST_VARDIR/
9
show session variables like 'secure_file_priv';
11
secure_file_priv MYSQLTEST_VARDIR/
12
select * from information_schema.global_variables where variable_name='secure_file_priv';
13
VARIABLE_NAME VARIABLE_VALUE
14
SECURE_FILE_PRIV MYSQLTEST_VARDIR/
15
select * from information_schema.session_variables where variable_name='secure_file_priv';
16
VARIABLE_NAME VARIABLE_VALUE
17
SECURE_FILE_PRIV MYSQLTEST_VARDIR/
18
set global secure_file_priv=1;
19
ERROR HY000: Variable 'secure_file_priv' is a read only variable
20
set session secure_file_priv=1;
21
ERROR HY000: Variable 'secure_file_priv' is a read only variable