List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 12 2001 10:08pm
Subject:Re: set variable
View as plain text  
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
Thread
set variablepam elliot12 Oct
  • Re: set variablePaul DuBois13 Oct