Hi! >>>>> "Sergei" == Sergei Golubchik <[email protected]> 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
