List:General Discussion« Previous MessageNext Message »
From:Darrell Shifflett Date:July 22 1999 2:40pm
Subject:Re: [Q]Why is mysql.log empty?
View as plain text  
On Thu, 22 Jul 1999, park seoung hong wrote:

> Hi everybody?
> Every day i met a message as follow;
> ~~~~
> Subject: errors rotating logs
> 
> errors occured while rotating /var/lib/mysql/mysql.log
> 
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> error running postrotate script
> ~~~~~~~
> 
> The /etc/logrotate.d/mysql is like below;
> --------
> /var/lib/mysql/mysql.log {                                                      
>         rotate 3                                                                
>         daily                                                                   
>         compress                                                                
>     postrotate                                                                  
>         mysqladmin flush-logs                                                   
>     endscript                                                                   
> }

Sounds like its looking for a password.....

Change to:

/var/lib/mysql/mysql.log {
         rotate 3
         daily
         compress
     postrotate
         mysqladmin -uroot -pyour_password flush-logs
     endscript
}


then:

chown root.mysql /etc/logrotate.d/mysql
chmod 0600 /etc/logrotate.d/mysql

Thread
[Q]Why is mysql.log empty?park seoung hong22 Jul
  • [Q]Why is mysql.log empty?sinisa22 Jul
  • Re: [Q]Why is mysql.log empty?Darrell Shifflett22 Jul