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