Fwd: Cron <root at coyote> run-parts /etc/cron.daily

[Justin W]

Gene Heskett wrote:
> On Sunday 27 May 2007, Tony Nelson wrote:
>   
>> At 9:27 AM -0400 5/27/07, Gene Heskett wrote:
>>     
>>> Hi folks;
>>>
>>> I've been trying to make this work, un-sucessfully so far.  I've set a
>>> password yadda yadda, but while I've spent an hour or more reading the
>>> manpages, nowhere in them did I stumble across a step by step on how to
>>> create, and initialize, a database called 'bugs'.
>>>
>>> Am I going blind in my advanced years, or is this bit of seemingly vital
>>> info actually on the missing list?
>>>
>>> Or better yet, since this is probably the result of an update, what package
>>> can I have smart remove in order to stop this daily nagging by cron?
>>>
>>> I also have noted that since this nagging started about 10 days ago, that
>>> my logwatch report no longer contains a section listing kernel bugs.  Is
>>> this related?
>>>
>>> ----------  Forwarded Message  ----------
>>>
>>> Subject: Cron <root at coyote> run-parts /etc/cron.daily
>>> Date: Sunday 27 May 2007
>>> From: Cron Daemon <root at coyote.coyote.den>
>>> To: root at coyote.coyote.den
>>>
>>> /etc/cron.daily/bugzilla:
>>>
>>>
>>> Can't connect to the database.
>>> Error: Access denied for user 'mysql'@'localhost' (using password: YES)
>>>       
>> This is the relevent part of the message.  It says it can't log in to the
>> mysql database.  It needs to log in to the mysql database.  It tried to use
>> a password but it did not work.  You should find out why.
>>
>>     
> 1.  There is no installed user 'mysql', or at least no home dir /home/mysql 
> exists.
>
> 2.  There is a password set for the user 'mysql' in the other default script, 
> which I think its reading because the message changed a bit when I did set 
> the password.  I also changed the password to match in the /etc/passwd file 
> using the passwd -u mysql command.
>
>   
MySQL keeps its own database of users and their passwords (by default at 
least. I've never looked into whether that can be changed).  Try reading 
up on mysqladmin which can change the MySQL users' passwords so that you 
can be certain you have the right password to log in with.