1SET @start_value = @@global.max_connect_errors; 2SELECT @start_value; 3@start_value 4100 5'#--------------------FN_DYNVARS_073_01------------------------#' 6SET @@global.max_connect_errors = 5000; 7SET @@global.max_connect_errors = DEFAULT; 8SELECT @@global.max_connect_errors; 9@@global.max_connect_errors 10100 11'#---------------------FN_DYNVARS_073_02-------------------------#' 12SET @@global.max_connect_errors = @start_value; 13SELECT @@global.max_connect_errors = 100; 14@@global.max_connect_errors = 100 151 16'#--------------------FN_DYNVARS_073_03------------------------#' 17SET @@global.max_connect_errors = 4096; 18SELECT @@global.max_connect_errors; 19@@global.max_connect_errors 204096 21SET @@global.max_connect_errors = 4294967294; 22SELECT @@global.max_connect_errors; 23@@global.max_connect_errors 244294967294 25SET @@global.max_connect_errors = 4294967295; 26SELECT @@global.max_connect_errors; 27@@global.max_connect_errors 284294967295 29SET @@global.max_connect_errors = 1; 30SELECT @@global.max_connect_errors; 31@@global.max_connect_errors 321 33SET @@global.max_connect_errors = 2; 34SELECT @@global.max_connect_errors; 35@@global.max_connect_errors 362 37'#--------------------FN_DYNVARS_073_04-------------------------#' 38SET @@global.max_connect_errors = -1; 39Warnings: 40Warning 1292 Truncated incorrect max_connect_errors value: '-1' 41SELECT @@global.max_connect_errors; 42@@global.max_connect_errors 431 44SET @@global.max_connect_errors = 100000000000; 45SELECT @@global.max_connect_errors; 46@@global.max_connect_errors 47100000000000 48SET @@global.max_connect_errors = 10000.01; 49ERROR 42000: Incorrect argument type to variable 'max_connect_errors' 50SELECT @@global.max_connect_errors; 51@@global.max_connect_errors 52100000000000 53SET @@global.max_connect_errors = -1024; 54Warnings: 55Warning 1292 Truncated incorrect max_connect_errors value: '-1024' 56SELECT @@global.max_connect_errors; 57@@global.max_connect_errors 581 59SET @@global.max_connect_errors = 0; 60Warnings: 61Warning 1292 Truncated incorrect max_connect_errors value: '0' 62SELECT @@global.max_connect_errors; 63@@global.max_connect_errors 641 65SET @@global.max_connect_errors = 4294967296; 66SELECT @@global.max_connect_errors; 67@@global.max_connect_errors 684294967296 69SET @@global.max_connect_errors = ON; 70ERROR 42000: Incorrect argument type to variable 'max_connect_errors' 71SELECT @@global.max_connect_errors; 72@@global.max_connect_errors 734294967296 74SET @@global.max_connect_errors = 'test'; 75ERROR 42000: Incorrect argument type to variable 'max_connect_errors' 76SELECT @@global.max_connect_errors; 77@@global.max_connect_errors 784294967296 79'#-------------------FN_DYNVARS_073_05----------------------------#' 80SET @@session.max_connect_errors = 4096; 81ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL 82SELECT @@session.max_connect_errors; 83ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable 84'#----------------------FN_DYNVARS_073_06------------------------#' 85SELECT @@global.max_connect_errors = VARIABLE_VALUE 86FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 87WHERE VARIABLE_NAME='max_connect_errors'; 88@@global.max_connect_errors = VARIABLE_VALUE 891 90SELECT @@max_connect_errors = VARIABLE_VALUE 91FROM INFORMATION_SCHEMA.SESSION_VARIABLES 92WHERE VARIABLE_NAME='max_connect_errors'; 93@@max_connect_errors = VARIABLE_VALUE 941 95'#---------------------FN_DYNVARS_073_07----------------------#' 96SET @@global.max_connect_errors = TRUE; 97SELECT @@global.max_connect_errors; 98@@global.max_connect_errors 991 100SET @@global.max_connect_errors = FALSE; 101Warnings: 102Warning 1292 Truncated incorrect max_connect_errors value: '0' 103SELECT @@global.max_connect_errors; 104@@global.max_connect_errors 1051 106'#---------------------FN_DYNVARS_073_08----------------------#' 107SET @@global.max_connect_errors = 5000; 108SELECT @@max_connect_errors = @@global.max_connect_errors; 109@@max_connect_errors = @@global.max_connect_errors 1101 111'#---------------------FN_DYNVARS_073_09----------------------#' 112SET max_connect_errors = 6000; 113ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL 114SELECT @@max_connect_errors; 115@@max_connect_errors 1165000 117SET local.max_connect_errors = 7000; 118ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_connect_errors = 7000' at line 1 119SELECT local.max_connect_errors; 120ERROR 42S02: Unknown table 'local' in field list 121SET global.max_connect_errors = 8000; 122ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_connect_errors = 8000' at line 1 123SELECT global.max_connect_errors; 124ERROR 42S02: Unknown table 'global' in field list 125SELECT max_connect_errors = @@session.max_connect_errors; 126ERROR 42S22: Unknown column 'max_connect_errors' in 'field list' 127SET @@global.max_connect_errors = @start_value; 128SELECT @@global.max_connect_errors; 129@@global.max_connect_errors 130100 131