MySQL on Ubuntu: Installing, Resetting the Root Password, and Importing a Database
A lost MySQL root password isn't actually unrecoverable — starting the server with --skip-grant-tables temporarily bypasses authentication entirely, just long enough to set a new one.