Comment 3 for bug 1153344

I'm sorry but that doesn't solve my issue. (I did check out: http://www.lornajane.net/posts/2008/Logrotate-Error-on-Ubuntu)

I already checked the user and password and all privileges and everything is correct.

There must be something else wrong. I tried every step of the: /etc/logrotate.d/mysql-server manually and everything seems correct.