Issue Daily logrotate cron not working anymore

[Johnny9977]

A few days ago I've changed my Plesk and server root password. After this I've had problem connection to the database after server restart. So I used the Plesk MySQL reset password script. All works fine, I can login and the database is also still accessable from the frontend. But today I've got this email from the server:

/etc/cron.daily/logrotate:
mysqladmin: 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

I've tried to add my password to

debian.cnf

(one time the password from the shadow file and the other time the clear password) but this had no effect. When I run the cron execution manually, I'm still getting the issue:

mysqladmin --defaults-file=/etc/mysql/debian.cnf --local flush-error-log
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

So any idea how I can fix this?

 

[Monty]

Have you tried the solution from here? Messages about failed logrotate task are received in Plesk on Ubuntu 18: 'Access denied for user 'root'@'localhost' (using password: NO)