Fix the logrotate file
The sources contains two versions of the logrotate file:
* mysql-8.0.30/support-files/mysql-log-rotate.in
* mysql-8.0.30/packaging/rpm-common/mysql.logrotate.in
Until now, the first one was used. However logfile location
specified in that logrotate configuration file was wrong.
( /var/lib/mysql/mysqld.log )
From now on, we will use the second one, which is meant to be
used in RPM packages, and which respects their FSH layout.
( /var/log/mysql/mysqld.log )
--
As a side-effect, the whole configuration is now commented out.
So users now need to touch the file before they can start using it.
However once the configuration is un-commented,
it will work out-of-the-box (unlike until now).
--
Resolves: #2073434