EVOLUTION-MANAGER

Edit File: max_user_connections_func.result

** Setup ** SET @default_max_user_connections = @@global.max_user_connections; Set Global max_user_connections=2; CREATE USER test@localhost; GRANT USAGE on *.* TO test@localhost; '#--------------------FN_DYNVARS_114_01-------------------------#' CONNECT conn1,localhost,test,,; CONNECT conn2,localhost,test,,; ERROR 42000: User test already has more than 'max_user_connections' active connections Expected error "too many connections" disconnect conn1; ** Poll till disconnected conn1 disappears from processlist '#--------------------FN_DYNVARS_114_02-------------------------#' connection default; Set Global max_user_connections=3; CONNECT conn5,localhost,test,,; CONNECT conn6,localhost,test,,; connection default; disconnect conn2; disconnect conn5; disconnect conn6; drop user test@localhost; SET @@global.max_user_connections = @default_max_user_connections;