How to change the max_user_connections value in MySQL/MariaDB on a Plesk server

Kuzma Ivanov

Updated August 06, 2025 14:21

Plesk for Windows kb: how-to Plesk for Linux ABT: Group B

Applicable to:

How to adjust the max_user_connections value in MySQL/MariaDB on a Plesk server?

For Plesk on Linux

Connect to your Plesk server via SSH.
Open the my.cnf file in a text editor. In this example, we are using vi editor:
- on CentOS/RHEL-based distributions
  
  # vi /etc/my.cnf
- on Debian/Ubuntu-based distributions
  
  # vi /etc/mysql/my.cnf
Add the following line under the [MySQLD] section:

# grep max_user_connections /etc/my.cnf
max_user_connections = 100
Save the changes and close the file.
Restart the MySQL/MariaDB service to apply the changes:

# systemctl restart mariadb

For Plesk on Windows Server

Connect to your Plesk server via RDP.
Open the file %plesk_dir%Databases\MySQL\my.ini in a text editor (just paste this path in Windows Explorer to open).
Increase the value of max_user_connections:

Note: If max_user_connections does not exist, add this line under the [MySQLD] section.

CONFIG_TEXT: max_user_connections = 100
Save the changes and close the file.
Open Plesk Services Monitor in Windows Start > All Programs > Plesk.
Select MySQL56 or MariaDB103 under the SQL Server section and click Restart to apply the changes.