At 10:31 AM +0800 5/11/01, Mark Lo wrote:
> I have make a my.cnf file in /etc and the permission is set to 644 and
>the ownership is set to root. When I try to restart MySQL. I got the
>error: Found option without preceding group in config file: /etc/my.cnf at
>Would you please tell me what I did wrong.
You have to specify a group name before any options or there is no
way for programs to know whether or not the option applies to them.
In this case, you probably want to use the [mysqld] group:
set-variable = max_connections=xxx
>----- Original Message -----
>From: "John Barton" <jbarton@stripped>
>To: "Mark Lo (3)" <mark@stripped>
>Cc: "ComMysql@Lists. Mysql." <mysql@stripped>
>Sent: Friday, May 11, 2001 12:53 AM
>Subject: Re: set variable for max_connections
>> Try putting a line like the following in your my.cnf file:
>> This has always worked for me, including 3.23.37
>> set-variable = max_connections=xxxx
>> John Barton
>> Unix Systems Administrator
>> Primary Networks, Inc.
>> On Thu, 10 May 2001, Mark Lo (3) wrote:
>> > Hi,
>> > I would like to set a higher values in max_connections for mysql.
>> > I have tried to use the following command "mysqld --set-variables
>> > max_connections=900 -u root -ppassword". Then, it shows that I have
>> > successfully changed the variable of max_connections. But, when I check
>> > with the command of "mysqladmin variables -u root -ppassword". The
>> > max_connections return to 100 which is the default value. I wonder what
>> > wrong with mysql3.23.37. Is this a bug, or I am using the wrong
>> > In additions, Can I set the max_connections values higher than 5000.
>> > Thank you
> > > Mark
> > >
Paul DuBois, paul@stripped