On Fri, 10 Jan 2003, Michael T. Babcock wrote:
> >if test -n "`ps acx|grep mysqld`"; then
> >/usr/bin/mysqladmin flush-logs
> >fi
> >
> >
>
> You're probably running it as root with the password loading from the
> /root/.my.cnf or something. Try adding the -uro
Jiann-Ming Su wrote:
if test -n "`ps acx|grep mysqld`"; then
/usr/bin/mysqladmin flush-logs
fi
You're probably running it as root with the password loading from the
/root/.my.cnf or something. Try adding the -uroot -p command-line
options, or a [mysqladmin]
I'm using mysql that was distributed by mysql.com. I seem to be having
a problem with logrotate. When I run logrotate manually on mysql only,
the logs seem to rotate fine. But, when it runs in the cron job, it
creates the new log, but mysql continues to log to the old log.
My mysql logrotate
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!
>
>
> I have added recently administrative user to mysql database:
Hello there!
I have added recently administrative user to mysql database:
#mysqladmin -u root password someposword
since then I'm getting every day such e-mail from logrotate demon:
Subject: errors rotating logs Message: errors occured while rotating /var/lib/mysql/mysql.log
mysqladmin: connec
