"Anders Gjermshus" <[EMAIL PROTECTED]> wrote:
> In the mysql documentation it stands:
>
> max_user_connections
>
> The maximum number of simultaneous connections allowed to any given MySQL
> account. A value of 0 means ``no limit.'' This variable was added in MySQL
> 3.23.34.
>
>
>
> In my configuration file I wrote: max_user_connections = 0
>
> That did not work, mysql automatically changed the value to 1, and that
> created some trouble fore me.
>
> Why is that? Is this a bug or Is it something I did wrong?
max_user_connections is set to 0 by dafault. If max_user_connections has another
value, use DEFAULT to set this variable to 0. For example:
mysql> select @@global.max_user_connections;
+-------------------------------+
| @@global.max_user_connections |
+-------------------------------+
| 5 |
+-------------------------------+
1 row in set (0.00 sec)
mysql> set @@global.max_user_connections=default;
Query OK, 0 rows affected (0.00 sec)
mysql> select @@global.max_user_connections;
+-------------------------------+
| @@global.max_user_connections |
+-------------------------------+
| 0 |
+-------------------------------+
1 row in set (0.00 sec)
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
