user "root" accidentally deleted

[johnccy]

i am mysql newbie, when i want to change mysql user password, accidentally i delete the root user, when i restart mysql service.. i can't connect to database any more.. it prompt out to say that there is no user "root" found.

can anyone help me?

rgds,
john

 

[KarveR]

When you install mysql theres a script to run which sets up the root account , run that again.

I thinks its called mysql_install_db or something like that, been a long time since I deleted root ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[johnccy]

i tried mysql_install_db under my /usr/bin directory, it run successfully, but the problem still maintain the same. please help.

rgds,
john

 

[piti]

you need to edit that script as there is a test if the default tables exist
i think uncommenting that test lines would help

 

[piti]

oops - i meant commenting them out

 

[johnccy]

any help file about mysql_install_db? i opened up this script but don't know where to make comment.. i meant where is the test lines..
thanks a lot..
:->

 

[piti]

well there's no help about changing this file ;-)
it's just a shell script, so what you need to look for is help for shell scripting
and to help you out, the lines are 205, 206 and 239
that should do the job

 

[johnccy]

i got it..
thanks..

rgds,
johnccy
%-)