List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 7 1999 5:44pm
View as plain text  
>>>>> "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!

logrotateDarrell Shifflett7 Jun
  • Re: logrotateSasha Pachev7 Jun
  • logrotateMichael Widenius7 Jun