Skip to content

Instantly share code, notes, and snippets.

@inouetakuya
Last active May 9, 2019 15:36
Show Gist options
  • Save inouetakuya/5201747 to your computer and use it in GitHub Desktop.
Save inouetakuya/5201747 to your computer and use it in GitHub Desktop.
/etc/logrotate.d/mysqld
# cat /etc/logrotate.d/mysqld
# This logname can be set in /etc/my.cnf
# by setting the variable "err-log"
# in the [safe_mysqld] section as follows:
#
# [safe_mysqld]
# err-log=/var/log/mysqld.log
#
# If the root user has a password you have to create a
# /root/.my.cnf configuration file with the following
# content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: This /root/.my.cnf should be readable ONLY
# for Root !
# Then, un-comment the following lines to enable rotation of mysql's log file:
# /var/log/mysqld.log {
# create 640 mysql mysql
# notifempty
# daily
# rotate 3
# missingok
# compress
# postrotate
# # just if mysqld is really running
# if test -x /usr/bin/mysqladmin && \
# /usr/bin/mysqladmin ping &>/dev/null
# then
# /usr/bin/mysqladmin flush-logs
# fi
# endscript
# }
@jianhaiqing
Copy link

mysql_config_editor set --login-path=logrotate --host=localhost --socket=xxx --user=root --port 3306 --password
would be better, wouldn't it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment