Hi,
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
following error.
error: Found option without preceding group in config file: /etc/my.cnf at
line: 1
Program aborted
Would you please tell me what I did wrong.
Thank You
Mark
----- Original Message -----
From: "John Barton" <[EMAIL PROTECTED]>
To: "Mark Lo (3)" <[EMAIL PROTECTED]>
Cc: "ComMysql@Lists. Mysql." <[EMAIL PROTECTED]>
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.
> [EMAIL PROTECTED]
>
> 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
it
> > with the command of "mysqladmin variables -u root -ppassword". The
> > max_connections return to 100 which is the default value. I wonder what
is
> > wrong with mysql3.23.37. Is this a bug, or I am using the wrong
command.
> >
> > In additions, Can I set the max_connections values higher than 5000.
> >
> > Thank you
> >
> > Mark
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
