Re: HOW TO EDIT THE HOSTS VARIABLES MAX_CONNECTIONS IN MYSQL

[Nick Roper]

Hi Alphonse.

There are a couple of ways:

Either

Add a startup option to the command-line:

mysqld --set-variable=max_connections=200

Or:

add the option in the [mysqld] section of the relevant my.cnf configuration file:

[mysqld]
other stuff...
set-variable = max_connections = 200

Note, the 'set-variable =' part of the statement is only required for MySQL versions < 4.1



--
Nick Roper