vim /root/.my.cnf
输入以下内容，其中<secret>是mysql帐号的root密码
[mysqladmin]
password = <secret> 
user= root

设置root属主可读写,其他用户无权查看
chmod 600 /root/.my.cnf

vim /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=/data/mysql_data/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 !

/home/mysql_log/*general_log.log {
        # create 600 mysql mysql
        notifempty
        daily
        rotate 60
        missingok
        compress
        dateext
    postrotate
        # just if mysqld is really running
        if test -x /usr/local/mysql-5.5.38/bin/mysqladmin && /usr/local/mysql-5.5.38/bin/mysqladmin ping &>/dev/null
        then
           /usr/local/mysql-5.5.38/bin/mysqladmin flush-logs
        fi
    endscript
}

logrotate -vf /etc/logrotate.d/mysqld