I think it would be easier to just go:
mysqladmin -uuser -ppassword
On Fri, 16 Mar 2001 11:09:37 -0500, Hardy Merrill
([EMAIL PROTECTED]) wrote:
>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 <mysql-unsubscribe-
>>[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 <mysql-unsubscribe-
>[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
