Howto: Solving problem with logrotate

Here you can find out how to solve a common problem with logrotate

/etc/cron.daily/logrotate:

error: error running shared postrotate script for /var/log/mysql.log
/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log

run-parts: /etc/cron.daily/logrotate exited with return code 1

Have you been getting this cryptic error message before?

Here is how to get rid of it:

View /etc/mysql/debian.cnf. Look for

user     = debian-sys-maint
password = newpass

Log into mysql as root

mysql -uroot -p

SET PASSWORD FOR `debian-sys-maint`@`localhost` = PASSWORD('newpass');
SET PASSWORD FOR `debian-sys-maint`@`%` = PASSWORD('newpass');
FLUSH PRIVILEGES;

Log out and it should be fixed.