mysql and debian / ubuntu clobbered debian-sys-maint user

home | blog | Terrible people and places | Covid-19 links | Teh Internet | guest blog |rants | placeholder | political | projects | Gwen and Liam | Citadel patched | Tools | Scouts

Did you clobber the user during an rsync or other bit of stupidity?

Fix it by changing the password in /etc/mysql/debian.cnf


GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '';

If you have another root user for MySQL.

Update 5/2/2016: Nice one liner from Shahar Evron here:
And in case the link or site goes away, here is the relevant bit:
echo "SET PASSWORD FOR 'debian-sys-maint'@'localhost' = PASSWORD('`sudo cat /etc/mysql/debian.cnf | grep password | head -n 1 |
awk -F= '{ gsub(/[ \t]+/, "", $2); print $2 }'`');" | mysql -u root -p