Thread: default my.cnf?
View Single Post

   
  #3 (permalink)  
Old 03-20-2008, 12:47 PM
Baron Schwartz
 
Posts: n/a
Default Re: default my.cnf?

Hi,

On Tue, Mar 18, 2008 at 1:06 PM, kalin m <kalin@el.net> wrote:
> hi all...
>
> i have a 5.0.33 build from source on a freebsd 4.10 machine...
>
> i'm looking for a my.cnf file.
>
> ps tells me that the base dir is /usr/local but there is no my.cnf
> there. and i cant find one anywhere.
> i can get all the variables set up from the cli but i need to change
> some of them. i guess i can use mysqladmin but just wondering - can i
> just do a cnf under /usr/local/etc with the variables i need to change?
>
> ktrace is showing me that mysqld is not looking for any .cnf?!
>
> i mean i can try that but it's a very busy server and i wouldn't mess to
> much with it.


You can ask mysqld where it looks for its configuration files. Here's
a Debian system:

baron@tigger ~ $ mysql --help --verbose | grep cnf
/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf
Reply With Quote