Re: set variable

[Paul DuBois]

At 5:58 PM -0400 10/12/01, pam elliot wrote:
>Can no longer remember the syntax for max_connections
>
>mysql>--set-variable max_connections=300
>
>However when I check variables by:
>mysql>show variables;
>
>The change is not taking affect.
>
>What am I forgetting????

To look in the manual? :-)

max_connections is a server parameter, you can't set it from the
mysql client program.

http://www.mysql.com/doc/C/o/Command-line_options.html

e.g.,

mysqld --set-variable max_connections=300

or you can put this in your my.cnf file:

[mysqld]
set-variable = max_connections=300


-- 
Paul DuBois, paul@stripped