[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysql/errors rotating logs

In a galaxy not too far away, Stefan Janecek spoke on Mon, Nov 13, 2000 at 11:18:49AM +0100:
> Hi!
> I installed mysql-server on my potato system and changed the password
> for the mysql root user afterwards. i think this is a good thing(tm),
> but now i'm getting the following error from cron/logrotate in my mail:
> 	Subject: errors rotating logs
>         errors occured while rotating /var/log/mysql.err
> 	^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
>       	error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>       	error running postrotate script
> ... and the same for /var/log/mysql.log. the files were rotated correctly,
> the problem seems to be in the 'postrotate script'. no clue what this one
> does, but apparently it wants to connect to the database - without
> password.
> I have set the root password by connecting to the database and issuing:
> 	SET PASSWORD FOR root=PASSWORD('xxxxxxxxx')
> ... is there a 'debian way' to do this? I don't have this problem on an
> old slink box, but do not remember how i set the password there :-(
> thanks in advance,
> /stefan.

sorry to have bothered you - but i found the solution in the meantime:
you have to put the password in /etc/logrotate.d/mysql-server, for 
anyone who is interested... maybe i should RTFM before asking 
stupid questions....


God is real, unless declared integer.

> -- 
> Unsubscribe?  mail -s unsubscribe debian-user-request@lists.debian.org < /dev/null

Reply to: