Description of problem:
The /etc/logrotate.d/mysqld configuration file has the following content:

# For the mysqladmin commands below to work, root account
# password is required. Use mysql_config_editor(1) to store
# authentication credentials in the encrypted login path file
# ~/.mylogin.cnf
#
# Example usage:
#
#  mysql_config_editor set --login-path=client --user=root --host=localhost --password
#
# When these actions has been done, un-comment the following to
# enable rotation of mysqld's log error.

However, on RHEL 9 logrotate no longer runs under cron but rather under systemd. As such there is no $HOME variable for the logrotate process, which causes in turn for mysql_config_editor to have no $HOME variable. This has the effect of making /root/.mylogin.cnf to never be read so only this gets printed in the logs:

logrotate[179140]: error: 'Access denied for user 'root'@'localhost' (using password: NO)'
logrotate[179136]: error: error running non-shared postrotate script for /var/log/mysql/mysqld.log of '/var/log/mysql/mysqld.log '

The workaround for this is to specify the HOME variable before both mysqladmin commands thus:

       if test -x /usr/bin/mysqladmin && \
          HOME=/root /usr/bin/mysqladmin ping &>/dev/null
       then
          HOME=/root /usr/bin/mysqladmin flush-logs
       fi

Version-Release number of selected component (if applicable):
mysql-server-8.0.32-1.el9_2.x86_64

How reproducible:
Every time

Steps to Reproduce:
1. Uncomment the /var/log/mysql/mysqld.log entry from /etc/logrotate.d/mysqld.
2. Run the following command as advised in the logrotate configuration file:
  # mysql_config_editor set --login-path=client --user=root --host=localhost --password
3. Wait for logrotate to run


Actual results:
mysqld log does not rotate properly.

Expected results:
mysqld log should rotate properly.


Additional info:
This was not an issue in RHEL 7/8 as logrotate ran under cron and, while cron does have a very limited environment, the $HOME variable was being passed to logrotate.

Also note, the package is mysql-server but for some reason it is not present in the component list.