Re: mysql root password

[Dave Baker <dsb3@earthlink.net>]

> Sometime, when i installed mysql ( don't know why exatcly ) the configure
> script advised me to set a root password. I yelled for the ghosts ( is it
> correct? ) and set one with
> myswladm password XXX
> ok, so far so good.
> 
> Every time when some apt script touches the database, it tries it without a
> password and exits.
> 
> How can i remove this nasty password or 
> How can i tell the scripts to use my password

I can answer the first, but haven't found out how to do the second.

I had this problem just recently so had to dig in and find what was up.

# mysqladmin password '' -p

this will now prompt for the OLD password and change it to '' (blank)

DONT FORGET TO SET IT BACK AGAIN ONCE APT IS DONE UPGRADING


If anyone knows the answer to the second q (how to have apt use the
correct password) I'd appreciate a cc: of the answer :-)


-dave


--
   |     oOOooO           /  
 --|    oOobodoO        /   dsb3@earthlink.net
 --|     ooOoOo       /    
   |       II       /     The wise man tells you where you have fallen
   |       II     /      and where you may fall - Invaluable secrets.