MySQL error 1203: User has more than max_user_connections
This account already has as many open connections as max_user_connections, or the account's own MAX_USER_CONNECTIONS limit, allows.
- Error number
1203- Name
ER_TOO_MANY_USER_CONNECTIONS- SQLSTATE
42000- Category
- Server limits and settings
What it means
Besides the server-wide max_connections, MySQL can cap connections per account, either globally with max_user_connections or for one account with MAX_USER_CONNECTIONS in CREATE USER or ALTER USER. 1203 means this account hit its cap, while other accounts may still connect.
Common causes
- A connection pool configured larger than the account's limit.
- Leaked connections from one application using a shared account.
- A deliberately low per-account limit on a hosted database.
How to fix it
-
Check the limits that apply.
SHOW VARIABLES LIKE 'max_user_connections'; SELECT user, host, max_user_connections FROM mysql.user WHERE user = 'app';
-
Raise the account's limit if appropriate.
ALTER USER 'app'@'%' WITH MAX_USER_CONNECTIONS 50;
-
Reduce the application's pool size or fix connection leaks.
Related errors
More server limits and settings errors
1153Got a packet bigger than max_allowed_packet1175Safe update mode blocked the statement1290Server option prevents this statement1114The table is full
The code and message text are from the MySQL 8.4 Error Message Reference. Browse the full MySQL error list or search every database error.
Work on MySQL in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for MySQL and the other databases you use.