MySQL default admin password on Ubuntu 7.10

After installing MySQL on Ubuntu 7.10 (Gutsy Gibbon) I couldn’t connect to the database. Usually MySQL is installed with a blank root password which you should immediately change. Here the package I installed already had the password set to something, but what? I found many blog and forum postings telling how to change the password – assuming you already knew it. And I found many saying that you would be prompted for an initial password when you installed it. Not so for me.

 I found the solution that worked at linuxweblog, posted by sandip. You start the safe daemon with an option to disable grant tables, and set the password. Don’t forget to kill the safe daemon and restart MySQL normally.


One Response to MySQL default admin password on Ubuntu 7.10

  1. Omear Syed says:

    Thank you so much, freshly installed LAMP server was giving me so many issues with connecting to mysql for the exact same reason, this was the ONLY thing that worked.
    Many thank’s 🙂

%d bloggers like this: