>>>>> "Darrell" == Darrell Shifflett <perl@stripped>
> writes:
Darrell> Redhat 6.0 with 3.22.22 MySQL rpms. MySQL sets up a file (mysql) in
Darrell> /etc/logrotate.d/ for rotating. I get errors saying root@localhost is
Darrell> denied access because not using a password when mysqladmin tries to do its
Darrell> job.
Darrell> ---
Darrell> ls -l /etc/logrotate.d/mysql
Darrell> -rw-r--r-- 1 root root mysql ; 0644
Darrell> /var/lib/mysql/mysql.log {
Darrell> rotate 3
Darrell> daily
Darrell> compress
Darrell> postrotate
Darrell> mysqladmin flush-logs
Darrell> endscript
Darrell> }
Darrell> Setting a password in the mysql rotate file with 0644 perms? Is this
Darrell> a safe way to do this.
To do this even safer, you could create a new MySQL user that is only
allowed to do 'flush' commands. This should be quite safe!
Regards,
Monty
