HELP!!! I deleted mysql user root

[QbertsBrother]

hello

i am hoping that someone can help me.

i accidently deleted the root user for mysql

i am using fedora 4.

if someone could help me get the root user back that would be heavenly.

thanks.

[kakariko81280]

There is an article in the documentation on how to reset the root password in mysql

It uses a custom init file to perform the password reset so you should be able to add a grant command in there to put a root user back on the database.

Let us know how you get on,

Chris...

[QbertsBrother]

thanks

i went thru the process and still i am not able to connect. i keep getting access denied. i dont think that it is recreating the root user.

when i did this

mysqld_safe --init-file=/var/lib/mysql/mysql-init &

it said this

Starting mysqld daemon with databases from /var/lib/mysql

and just sat there and did nothing else.

do you think that if i upgrade the database to mysql 5 it will recreate the root user?

[QbertsBrother]

i got it.

i had to restart mysql without the init-file after i started it with the init-file and i had my root user back.

thanks