[Case 159129] Upgrade to MariaDB MAX_USER_CONNECTIONS problem

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?

 

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?

 

Update
max_user_connections is now showing the adjusted figure and so we can now use the WHM MySQL/MariaDB upgrade tool.
Thank you