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
