Edit file

File name : mysqld

Content :/var/log/mysql.error.log { create 640 mysql root notifempty daily rotate 5 missingok nocompress nocopytruncate dateext sharedscripts postrotate env HOME=/root/ /usr/bin/mysql -e 'flush logs' endscript }

Save