From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.6) Gecko/20011121 Description of problem: In the logrotate script /etc/logrotate.d/mysqld, we call the command '/usr/bin/mysqladmin flush-logs'. On my system, this leads to the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Of course the user root@localhost has a password on my machine. If I run the flush-logs command with '-p' and interactively give the password it works just fine. Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. install and configure mysql-server, logrotate and cron 2. set mysql-root password 3. setup some database or other 4. wait for cron error message Actual Results: Cron calls logrotate which executes /etc/logrotate.d/mysqld. This fails with the error message /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Cron notifies me about that in an e-mail Expected Results: The script should have executed successfully and silently Additional info: anacron-2.3-17 crontabs-1.10-1 logrotate-3.5.9-1 mysql-3.23.41-1 mysql-devel-3.23.41-1 mysql-server-3.23.41-1 mysqlclient9-3.23.22-6 vixie-cron-3.0.1-63 Please see attachment for a dump of the user and host tables.
Created attachment 41895 [details] dump of user and host tables in the mysql database
A problem is that killing it instead of using mysqladmin disturbs logs and (reportedly) replication. I agree the current situation is far from ideal.
Fixed in 3.23.47-4