in the postrotate section, you have to add the user and password parameters to mysqladmin: mysqladmin -u someuser --password=somepassword flush-logs
s.m. Am Donnerstag, 21. März 2002 19:23 schrieben Sie: > Hello there! > <nl><nl> > > I have added recently administrative user to mysql database: > <nl><nl> > > #mysqladmin -u root password someposword > <nl><nl> > > since then I'm getting every day such e-mail from logrotate demon: > <nl><nl> > > Subject: > errors rotating logs > Message: > errors occured while rotating /var/lib/mysql/mysql.log > <nl><nl> > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > error running postrotate script > <nl><nl> > > My rogrotate demon have such configuration file for mysql: > /var/lib/mysql/mysql.log { > <nl> rotate 3 > <nl> daily > <nl> compress > <nl> postrotate > <nl> mysqladmin flush-logs > <nl> endscript > } > <nl><nl> > > Any advice will be greatly appreciated! > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php