MariaDB: Set Maximum Server Connections via Query

If you’re a MariaDB user and need to set the max_connections variable a little higher while the server is running, you can use the following SQL query:

# This will give you the current mac_connections setting
select @@max_connections;

Set the maximum connections allow for MariaDB

set global max_connections = 200;

# To see that the variable has been changed, run the following query again:
select @@max_connections;