I'm configuring new server to run mySQL (3.22.25) on Linux RH6.0
After I configured password for root access and added couple users
for other databases, I started getting the following message from cron:
=====================================================================
Date: Sun, 1 Aug 1999 04:02:01 -0400
From: root <root@stripped>
To: root@stripped
Subject: errors rotating logs
errors occured while rotating /var/lib/mysql/mysql.log
^Gmysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
error running postrotate script
==========================================================================
Do I have to add root password to a logrotate script now? Which one/where
is it located?
Thanks for your help.
Regards,
A.Heiphetz
P.S. never had this problem on FreeBSD, why?