[Case 159129] Upgrade to MariaDB MAX_USER_CONNECTIONS problem

kernow

Well-Known Member
Jul 23, 2004
1,015
61
178
cPanel Access Level
Root Administrator
Tried to upgrade to mariaDB through WHM but get a warning that
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.
OK, so I check :
Code:
SHOW VARIABLES LIKE 'max_user_connections';
+----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)
Wow that seems a lot! so I try to change it:
Code:
SET GLOBAL max_user_connections = 2147483647;
Query OK, 0 rows affected (0.00 sec)
Nothing happens. The original figure still shows up and the upgrade through WHM also shows the same high figure;
Code:
SHOW VARIABLES LIKE 'max_user_connections';
+----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)
Any suggestions please?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,236
463
Hello :)

Internal case number 159129 is open to address this issue. In the meantime, try this workaround:

1.) Examine /etc/my.cnf to ensure max_user_connections is within a range of 0 to 2147483647.

2.) In 'mysql' database, 'user' table, ensure entries for user root are within a range of 0 to 2147483647.

Code:
mysql -e "SELECT Host,User,max_questions,max_updates,max_connections,max_user_connections FROM mysql.user WHERE User='root' \G"
Manually reset the mysql.user values (if needed):

Code:
export MAX_SIGNED_INT=2147483647; mysql -e "UPDATE mysql.user set MAX_USER_CONNECTIONS=$MAX_SIGNED_INT, MAX_UPDATES=$MAX_SIGNED_INT, MAX_CONNECTIONS=$MAX_SIGNED_INT, MAX_QUESTIONS=$MAX_SIGNED_INT where user='root';"
Thank you.
 

kernow

Well-Known Member
Jul 23, 2004
1,015
61
178
cPanel Access Level
Root Administrator
Hi,
Thanks but it didn't work. After edit we get:
Code:
mysql -e "SELECT Host,User,max_questions,max_updates,max_connections,max_user_connections FROM mysql.user WHERE User='root' \G"
*************************** 1. row ***************************
                Host: localhost
                User: root
       max_questions: 2147483647
         max_updates: 2147483647
     max_connections: 2147483647
max_user_connections: 2147483647
But:
Code:
mysql> SHOW VARIABLES LIKE 'max_user_connections';                                                                                                                                         +----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| max_user_connections | 4294967295 |
+----------------------+------------+
1 row in set (0.00 sec)
I think your suggestion only changed roots connection limit which I belive was already fixed?
case 157165: Ensure root's MySQL/MariaDB MAX_USER_CONNECTION is set to a sane value
 
Last edited: