Re: [Maria-discuss] 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.