Posts Tagged ‘MySQL’

Finally fixed mysql

Tuesday, October 16th, 2007

Took my sweet time but i finally fixed my mysql problem - at some point when I set my mail server up i screwed up the debian-sys-maint account. This meant that the init script kept failing and apt-get upgrade wouldn’t work.

If anyone else hits a problem with their debian-sys-maint account, you can find its password in /etc/mysql/debian.cnf. You can then mysql -u root -p and do something like:

USE mysql;
UPDATE users SET password=PASSWORD('password-from-debian.cnf') WHERE user='debian-sys-maint';
FLUSH PRIVILEGES;

Solved.


Bad Behavior has blocked 65 access attempts in the last 7 days.