Re: Mysql's root password

[doug@digitalavenue.org]

 What I would do i move the current tables including mysql to a safe place and
rerun scripts/mysql_install_db, that will replace the mysql table. Then put the
tables back into the data directory but make sure the old mysql table is oldmysql
or something different than the current mysql table. Use the old mysql table,
remove or replace roots password and copy the old table over the new one. I
haven't had to actually do this but it seems like it should work. Just remember to
keep a backed up copy of all your old tables.

Doug


> Hi
> 
> I forgot mysql's root password. Anyone has any suggestion on what I
> should do to be able to clear it...
> 
> Thanks
> -- 
>         Mario Filipe 
>         mjnf@uevora.pt
>         http://neptuno.sc.uevora.pt/~mjnf