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

Connect to a Plesk server via SSH.

Open the my.cnf file in a text editor. In this example we are using the 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:

# service mysql restart

# service mariadb restart

Connect to a Plesk server via RDP.

Open the file %plesk_dir%DatabasesMySQLmy.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.

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 chnages.