logrote executes 'mysqladmin flush-log'

[walter@yippi-yeah.com]

It's about the debian potato package 'logrotate'.

Package: logrotate
Version: 3.2-11

We're developing software for ISP's and a customer gets this
error message in his inbox:

Subject: errors rotating logs
Status: O

errors occured while rotating /var/log/mysql.log

^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
error running postrotate script

Our software set's a MySQL password for root but the script under:

	/etc/logroate.d/mysql-server

of course doesn't use this.

A Workaround could be to add it to the mysqladmin command. The
question I have is if it leeds to issues in the case we restrict
permissions only for root and if there's a different way to use
mysqladmin without a 'root' password. ( It's a productive system
and I won't restrict /etc/logroate.d/mysql-server without knowledge
of the consequences.

--
Best Regards,

Mark