← Back to team overview

maria-discuss team mailing list archive

Re: Does server reads /root/.my.cnf

 

Στις Δευτέρα 04 Απρίλιος 2011 11:21:48 Sergei Golubchik γράψατε:
> > Hi.
> > 
> > # less .my.cnf
> > [mysqld_safe]
> > log-error=/var/log/mysql/error.log
> > 
> > 
> > [mysqld]
> > log-error=/var/log/mysql/error.log
> > 
> > 
> > Also i have disabled  syslog.
> > But after restarting the server no  errol.log is created.
> > 
> > So does mysqld reads /root/.my.cnf ?
> > 
> > Alexandros
> 
> Run mysqld --help --verbose.
> It will print something like:
> 
> ...
> Default options are read from the following files in the given order:
> /etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
> The following groups are read: mysqld server mysqld-5.1 mariadb mariadb-5.1
> ...
> 
> And you'll see what files and what groups it reads.
> 
> Regards,
> Sergei

Thanks very much for the hint.

Alexandros.



References