Re: mysql logfile rotate error

[Ajay Sharma <ssharma odc net>]

> errors occured while rotating /var/log/mysqld.log {
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root localhost' (Using password: NO)'
> error running prerotate script -- 
> 				leaving old log in place

look in /etc/logrotate.d/mysqld for the 'prerotate' section.  That'll 
tell you what it's trying to do before rotating the log files.  It looks 
like it's trying to log into the mysql server running on localhost 
without a password.  So maybe you can supply it a password and it'll 
work??  If you do that adjust the permissions on that file so only root 
can read it.

If that file isn't there looking for anything in that /etc/logrotate.d
directory that's trying to modify 'mysqld.log'.  You can also check
/etc/logrotate.conf.

later,
ajay

--------------------------------------------------------------------
Satyajot (Ajay) Sharma 
ssharma odc net
--------------------------------------------------------------------