Find the answer to your Linux question:
Results 1 to 4 of 4
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Sep 2007
    Posts
    96

    HELP!!! I deleted mysql user root


    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.

  2. #2
    Linux Enthusiast
    Join Date
    Apr 2004
    Location
    UK
    Posts
    682
    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...
    To be good, you must first be bad. "Newbie" is a rank, not a slight.

  3. #3
    Just Joined!
    Join Date
    Sep 2007
    Posts
    96
    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
    Code:
    mysqld_safe --init-file=/var/lib/mysql/mysql-init &
    it said this
    Code:
    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?

  4. #4
    Just Joined!
    Join Date
    Sep 2007
    Posts
    96
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •