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; 45Warnings: 46Warning 1292 Truncated incorrect max_connect_errors value: '100000000000' 47SELECT @@global.max_connect_errors; 48@@global.max_connect_errors 494294967295 50SET @@global.max_connect_errors = 10000.01; 51ERROR 42000: Incorrect argument type to variable 'max_connect_errors' 52SELECT @@global.max_connect_errors; 53@@global.max_connect_errors 544294967295 55SET @@global.max_connect_errors = -1024; 56Warnings: 57Warning 1292 Truncated incorrect max_connect_errors value: '-1024' 58SELECT @@global.max_connect_errors; 59@@global.max_connect_errors 601 61SET @@global.max_connect_errors = 0; 62Warnings: 63Warning 1292 Truncated incorrect max_connect_errors value: '0' 64SELECT @@global.max_connect_errors; 65@@global.max_connect_errors 661 67SET @@global.max_connect_errors = 4294967296; 68Warnings: 69Warning 1292 Truncated incorrect max_connect_errors value: '4294967296' 70SELECT @@global.max_connect_errors; 71@@global.max_connect_errors 724294967295 73SET @@global.max_connect_errors = ON; 74ERROR 42000: Incorrect argument type to variable 'max_connect_errors' 75SELECT @@global.max_connect_errors; 76@@global.max_connect_errors 774294967295 78SET @@global.max_connect_errors = 'test'; 79ERROR 42000: Incorrect argument type to variable 'max_connect_errors' 80SELECT @@global.max_connect_errors; 81@@global.max_connect_errors 824294967295 83'#-------------------FN_DYNVARS_073_05----------------------------#' 84SET @@session.max_connect_errors = 4096; 85ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL 86SELECT @@session.max_connect_errors; 87ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable 88'#----------------------FN_DYNVARS_073_06------------------------#' 89SELECT @@global.max_connect_errors = VARIABLE_VALUE 90FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 91WHERE VARIABLE_NAME='max_connect_errors'; 92@@global.max_connect_errors = VARIABLE_VALUE 931 94SELECT @@max_connect_errors = VARIABLE_VALUE 95FROM INFORMATION_SCHEMA.SESSION_VARIABLES 96WHERE VARIABLE_NAME='max_connect_errors'; 97@@max_connect_errors = VARIABLE_VALUE 981 99'#---------------------FN_DYNVARS_073_07----------------------#' 100SET @@global.max_connect_errors = TRUE; 101SELECT @@global.max_connect_errors; 102@@global.max_connect_errors 1031 104SET @@global.max_connect_errors = FALSE; 105Warnings: 106Warning 1292 Truncated incorrect max_connect_errors value: '0' 107SELECT @@global.max_connect_errors; 108@@global.max_connect_errors 1091 110'#---------------------FN_DYNVARS_073_08----------------------#' 111SET @@global.max_connect_errors = 5000; 112SELECT @@max_connect_errors = @@global.max_connect_errors; 113@@max_connect_errors = @@global.max_connect_errors 1141 115'#---------------------FN_DYNVARS_073_09----------------------#' 116SET max_connect_errors = 6000; 117ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL 118SELECT @@max_connect_errors; 119@@max_connect_errors 1205000 121SET local.max_connect_errors = 7000; 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 'local.max_connect_errors = 7000' at line 1 123SELECT local.max_connect_errors; 124ERROR 42S02: Unknown table 'local' in field list 125SET global.max_connect_errors = 8000; 126ERROR 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 'global.max_connect_errors = 8000' at line 1 127SELECT global.max_connect_errors; 128ERROR 42S02: Unknown table 'global' in field list 129SELECT max_connect_errors = @@session.max_connect_errors; 130ERROR 42S22: Unknown column 'max_connect_errors' in 'field list' 131SET @@global.max_connect_errors = @start_value; 132SELECT @@global.max_connect_errors; 133@@global.max_connect_errors 134100 135