How do I tell mysqladmin to use a password when rotating logs and what that password is? I get a daily email that says it's unable to log into the database: /etc/cron.daily/logrotate: ^Gmysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' error: error running shared postrotate script for '/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log ' run-parts: /etc/cron.daily/logrotate exited with return code 1 Everything else seems to work properly. Thanks, Bob
Thanks, Till! I think that fixed it. I'd looked at that file at some point, but it contained a comment that it was automatically generated and not to modify it. Thanks for the help! Bob
I have the same problem. Bob, have you finally edited the /etc/mysql/debian.cnf file? Have you put the root password in plain text in this configuration file? Thanks