Charles,
I think I know what's happening - your MySQL "root" user has
a password, and "mysqladmin" wants a password before it will
execute for "root". If you want to run mysqladmin through
cron(as a part of logrotate), you'll need to use an option file
in the unix "root" user's home account(.my.cnf in "root's
home directory) where you specify something like this:
[mysqladmin]
user=root
password=root_password
That way mysqladmin will run from the unix "root" user, and
will pick up the user and password from the option file, so
it can run unattended. From then on, when you run mysqladmin
from the Unix "root" user, by default it will run as the MySQL
"root" user, and you won't have to type in the MySQL "root"
user's password.
There is a GOTCHA - just be aware that when you use option
files to give defaults for things, those defaults can be
overridden on the command line, but options NOT specified
on the command line that *ARE* present in the option file
will be taken from the option file.
=================================
====== Be Aware =================
=================================
BE AWARE that it is advisable to create a UNIX *NON* "root"
lesser-privileged user for MySQL administration purposes
(running "mysqladmin" for instance) - then scheduled jobs
for MySQL can be run from that non-root user - you could
put an option file in that unix user's home directory to give
defaults for commands that it will run.
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Charles L Hagen [[EMAIL PROTECTED]] wrote:
> Found this message from mysql in my root mailbox. What does it mean?
>
> "errors occured while rotating /var/lib/mysql/mysqld.log {
>
> ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> error running postrotate script"
>
>
> --
> Charles L. Hagen
> Engineer
> Hagen IT
> 920-261-8499
>
>
> ---------------------------------------------------------------------
> 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
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
---------------------------------------------------------------------
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
