怎样限制登录数据库的用户数量

-- 创建一个新用户并限制其并发连接数
CREATE USER 'limiteduser'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT ON mydatabase.* TO 'limiteduser'@'localhost';
SET GLOBAL max_user_connections = 10;

-- 创建一个新用户并限制其并发连接数
CREATE USER limiteduser WITH PASSWORD 'password';
GRANT SELECT, INSERT ON mydatabase TO limiteduser;
ALTER SYSTEM SET max_connections = 10;

[databases]
mydatabase = host=127.0.0.1 port=5432 dbname=mydatabase

[pgbouncer]
listen_addr = 127.0.0.1
listen_port = 6432
auth_type = md5
auth_file = users.txt
pool_mode = transaction
max_client_conn = 10
default_pool_size = 10
reserve_pool_size = 5
reserve_pool_timeout = 5