Debian Codegraph @

mysql-test/suite/sys_vars/r/secure_file_priv_basic.result

raw
1 select @@global.secure_file_priv;
2 @@global.secure_file_priv
3 MYSQLTEST_VARDIR/
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';
7 Variable_name Value
8 secure_file_priv MYSQLTEST_VARDIR/
9 show session variables like 'secure_file_priv';
10 Variable_name Value
11 secure_file_priv MYSQLTEST_VARDIR/
12 select * from performance_schema.global_variables where variable_name='secure_file_priv';
13 VARIABLE_NAME VARIABLE_VALUE
14 secure_file_priv MYSQLTEST_VARDIR/
15 select * from performance_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