Description:
Specify a large value of max_user_connections when creating a user, and store a random number in the system table
How to repeat:
create user test4 with max_user_connections 4294967297;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from mysql.user where User = "test4"\G
*************************** 1. row ***************************
Host: %
User: test4
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
Create_tablespace_priv: N
ssl_type:
ssl_cipher: NULL
x509_issuer: NULL
x509_subject: NULL
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 1
plugin: caching_sha2_password
authentication_string:
password_expired: N
password_last_changed: 2021-09-23 17:15:11
password_lifetime: NULL
account_locked: N
Create_role_priv: N
Drop_role_priv: N
Password_reuse_history: NULL
Password_reuse_time: NULL
Password_require_current: NULL
User_attributes: NULL
Suggested fix:
When the specified size exceeds the maximum value, an error is reported or set to the maximum value and an alarm is reported.