1SET @start_value= @@global.log_syslog_facility;
2SET @@global.log_syslog_facility= DEFAULT;
3SELECT @@global.log_syslog_facility;
4@@global.log_syslog_facility
5daemon
6SET @@global.log_syslog_facility="user";
7SELECT @@global.log_syslog_facility;
8@@global.log_syslog_facility
9user
10SET @@global.log_syslog_facility= "daemon";
11SELECT @@global.log_syslog_facility;
12@@global.log_syslog_facility
13daemon
14SET @@global.log_syslog_facility= "local0";
15SELECT @@global.log_syslog_facility;
16@@global.log_syslog_facility
17local0
18SET @@global.log_syslog_facility= "log_local5";
19SELECT @@global.log_syslog_facility;
20@@global.log_syslog_facility
21local5
22SET @@global.log_syslog_facility= "LOG_LOCAL7";
23SELECT @@global.log_syslog_facility;
24@@global.log_syslog_facility
25local7
26SET @@global.log_syslog_facility= "9";
27ERROR 42000: Variable 'log_syslog_facility' can't be set to the value of '9'
28SET @@global.log_syslog_facility= "local8";
29ERROR 42000: Variable 'log_syslog_facility' can't be set to the value of 'local8'
30SET @@global.log_syslog_facility= "";
31ERROR 42000: Variable 'log_syslog_facility' can't be set to the value of ''
32SET @@global.log_syslog_facility= 9;
33ERROR 42000: Incorrect argument type to variable 'log_syslog_facility'
34SET GLOBAL log_syslog_facility= 0.01;
35ERROR 42000: Incorrect argument type to variable 'log_syslog_facility'
36SET SESSION log_syslog_facility= "local1";
37ERROR HY000: Variable 'log_syslog_facility' is a GLOBAL variable and should be set with SET GLOBAL
38SET LOCAL log_syslog_facility= "local1";
39ERROR HY000: Variable 'log_syslog_facility' is a GLOBAL variable and should be set with SET GLOBAL
40SET @@global.log_syslog_facility= @start_value;
41