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.


mysqld --set-variable max_connections=300

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

set-variable = max_connections=300

Paul DuBois, paul@stripped
set variablepam elliot12 Oct
  • Re: set variablePaul DuBois13 Oct