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.
 

Comments:

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 :)

Posted by Omear Syed on December 13, 2007 at 06:26 AM PST #

Post a Comment:
Comments are closed for this entry.
About

I am a software engineer in San Diego, president of the Standard Performance Evaluation Corporation (spec.org), formerly a mathematician and a violist.

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today