Re: [webmin-l] MySql still stuck and hating life!!

[Craig W. <cra...@az...>]

On Sat, 2004-03-06 at 14:10, Gary Wells wrote:
> Well got some good advice and decided to uninstall MySql and then
> reinstall it.  Thought for sure that would do the trick.  But guess
> what? NO DICE!! LOL
>  
> I still have no access rights to control anything that has anything to
> do with MySql.
>  
> After reinstalling it still shows the old MySql databases that were
> there before.  It seams like I cant even remove them by uninstalling
> them.  I guess that I could always flush the entire server and start
> from scratch but that seams a little drastic to me.  What would also
> help is to know if this has happened before to anyone and also what I
> did to create this mess.
>  
> Thanks again and the responses so far have been very enlightening.
----
I don't know the system you are using but on a redhat system...

service mysqld stop
mv /var/lib/mysql/mysql/user* /tmp

service mysqld start
mysqladmin -u root password 'new-password'
mysqladmin -u root@localhost password 'new-password' #just to be safe...

Craig