Tried to upgrade to mariaDB through WHM but get a warning that
OK, so I check :
Wow that seems a lot! so I try to change it:
Nothing happens. The original figure still shows up and the upgrade through WHM also shows the same high figure;
Any suggestions please?
Code:
Your server’s MySQL/MariaDB MAX_USER_CONNECTIONS value is larger then 2147483647. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state.
Code:
SHOW VARIABLES LIKE 'max_user_connections';
+----------------------+------------+
| Variable_name | Value |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)
Code:
SET GLOBAL max_user_connections = 2147483647;
Query OK, 0 rows affected (0.00 sec)
Code:
SHOW VARIABLES LIKE 'max_user_connections';
+----------------------+------------+
| Variable_name | Value |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)