Monday, April 5, 2010

Resetting MySQL debian-sys-maint Password in Ubuntu

Occasionally, for various reasons, the MySQL debian-sys-maint password may be reset. Here's how to recover it. Instructions swiped from the following forum.

Find your debian-sys-maint password in /etc/mysql/debian.cnf.

Then use
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
Replace with your debian-sys-maint password.

Then, of course:

FLUSH privileges;

That's it!