If you have lost or forgotten your MySQL root password on Ubuntu (or Debian) then the following will help you reset it without having to shut the server down.