# If the root user has a password you have to alter the
# /var/lib/mysql/my.cnf configuration file with the following
# content:
#
# [mysqladmin]
# password = <secret> 
# user= root
#
# where "<secret>" is the password. 
#
# ATTENTION: This /var/lib/mysql/my.cnf file MUST be available
# for read and write ONLY for root !

/var/log/mysql/* {
	notifempty
	missingok
	nocompress
	weekly
}

/var/lib/mysql/log/* {
	notifempty
	missingok
	daily
	prerotate
		if [ -e /var/lock/subsys/mysqld ]; then mysqladmin flush-logs; fi
	endscript
	postrotate
		if [ -e /var/lock/subsys/mysqld ]; then mysqladmin flush-logs; fi
	endscript
}