[Maria-discuss] Does server reads /root/.my.cnf
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
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
Hi!
"Sergei" == Sergei Golubchik <serg@askmonty.org> 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: log-error=/var/log/mysql/error.err or log-error=/var/log/mysql/error 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 Regards, Monty
Στις Δευτέρα 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.
participants (3)
-
Michael Widenius -
Sergei Golubchik -
Πρεκατές Αλέξανδρος