|
In MariaDB 10.2 MAX_USER_CONNECTIONS cannot be set to a value greater than 2147483647. In MySQL 5.7 bigger values work.
I don't think it makes a practical difference, but better check if it's intentional, because the produced error code is strange – it fails with a syntax error, not with an overflow or anything like that.
|
10.2
|
MariaDB [test]> CREATE USER foo IDENTIFIED BY 'Aabcd1$ee' WITH MAX_USER_CONNECTIONS 2147483648;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2147483648' at line 1
|
MariaDB [test]> CREATE USER foo IDENTIFIED BY 'Aabcd1$ee' WITH MAX_USER_CONNECTIONS 2147483647;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> select @@version;
|
+----------------------+
|
| @@version |
|
+----------------------+
|
| 10.2.3-MariaDB-debug |
|
+----------------------+
|
1 row in set (0.00 sec)
|
|
MySQL 5.7
|
MySQL [test]> CREATE USER foo IDENTIFIED BY 'Aabcd1$ee' WITH MAX_USER_CONNECTIONS 2147483648;
|
Query OK, 0 rows affected (0.01 sec)
|
|
MySQL [test]> select @@version;
|
+--------------+
|
| @@version |
|
+--------------+
|
| 5.7.16-debug |
|
+--------------+
|
1 row in set (0.00 sec)
|
|