Every two weeks or something my MySQL root pw is magically reset after reboot. I'm running a virtual server (Ubuntu 12.04) and it's running fine for approx. 2 weeks. Every two weeks (approx.) i'm seeing a
/etc/mysql/debian-start: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
error and when i try to login to MySQL my root pw stops working (Error 1045 (28000): access denied for user 'root'@'localhost' (using password: YES).
I know how to re add the debian-sys-maint user and reset the MySQL password, but i'd like to know why this happens (and works fine for weeks without doing so). I don't any suspicious log entries. Not sure this is related somehow, but named was restarting due some errors which seems to trigger a MySQL restart (?) and directly after the named restart i'm seeing the "access denied for" errors.
Actually i can't even say if the password resets or i'm getting a denied error on login for other reasons (hostname, named/DNS?).