← Back to team overview

maria-discuss team mailing list archive

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



>>>>> "Sergei" == Sergei Golubchik <serg@xxxxxxxxxxxx> writes:

>> Hi.
>> # less .my.cnf 
>> [mysqld_safe]
>> log-error=/var/log/mysql/error.log
>> [mysqld]
>> log-error=/var/log/mysql/error.log

Note that the default extension for the error log is .err, so I
suggest you instead use:


Note also that mysqld_safe also reads the [mysqld] section so you
don't need to have [mysqld_safe] + log-error above.

>> Also i have disabled  syslog.
>> But after restarting the server no  errol.log is created.
>> So does mysqld reads /root/.my.cnf ? 
>> Alexandros 

Sergei> Run mysqld --help --verbose.
Sergei> It will print something like:

Sergei> ...
Sergei> Default options are read from the following files in the given order:
Sergei> /etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 
Sergei> The following groups are read: mysqld server mysqld-5.1 mariadb mariadb-5.1
Sergei> ...

You can also use the tool 'my_print_defaults' to get information about
the options passed to mysqld or mysqld_safe.

Try following commands to see what is happening:

my_print_defaults mysqld

my_print_defaults mysqld_safe mysqld server