Setting max_connections to 1 is possible on MySQL 5.7 and 8.0, but doesn't work with recent versions of MariaDB. The documentation seems to indicate it should work as it gives the range from 1 to 100000.
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'max_connections';
|
+-----------------+-------+
|
| Variable_name | Value |
|
+-----------------+-------+
|
| max_connections | 100 |
|
+-----------------+-------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> SET GLOBAL max_connections=1;
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
MariaDB [(none)]> show warnings;
|
+---------+------+------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------+
|
| Warning | 1292 | Truncated incorrect max_connections value: '1' |
|
+---------+------+------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'max_connections';
|
+-----------------+-------+
|
| Variable_name | Value |
|
+-----------------+-------+
|
| max_connections | 10 |
|
+-----------------+-------+
|
1 row in set (0.00 sec)
|
(I've tagged the specific versions I've tested, but it's obviously likely to affect other 10.2 and 10.3 versions as well.)
Bug
Minor