Duplicate log entry for /var/lib/mysql/mysqld.log

Issue

The following error is presented by logrotate:

/etc/cron.daily/logrotate:
error: mysqld:21 duplicate log entry for /var/lib/mysql/mysqld.log

Environment

• MySQL/MariaDB
• CloudLinux OS

Solution

The solution is to remove the "mysql" entry, as it's conflicting with "mysqld":

~# ls -lsa /etc/logrotate.d/mysql*
/etc/logrotate.d/mysql
/etc/logrotate.d/mysqld
~# rm /etc/logrotate.d/mysql