// MySQL error reference

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
Error message
User %s already has more than 'max_user_connections' active connections

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

  1. Check the limits that apply.

    SHOW VARIABLES LIKE 'max_user_connections';
    SELECT user, host, max_user_connections FROM mysql.user WHERE user = 'app';
  2. Raise the account's limit if appropriate.

    ALTER USER 'app'@'%' WITH MAX_USER_CONNECTIONS 50;
  3. Reduce the application's pool size or fix connection leaks.

Related errors

More server limits and settings errors

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.

// fewer errors, faster fixes

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.