Issue Cron daemon email every day - mysqladmin: connect to server at 'localhost' failed

[Ian Bélisle]

Hi,
I start a new server with ubuntu 18.04 and install a fresh copy of Plesk with the automatic installer.
I tried 2 times a fresh installation and always get the same error.
I receive an email everyday from Cron daemon:

/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


Thank you

 

[IgorG]

This KB article will help you - Messages about failed logrotate task are received: 'Access denied for user 'root'@'localhost' (using password: NO)

 

[Ian Bélisle]

This KB article will help you - Messages about failed logrotate task are received: 'Access denied for user 'root'@'localhost' (using password: NO)

Doesn't work

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