Find the answer to your Linux question:
Results 1 to 4 of 4
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    HELP!!! I deleted mysql user root


    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.


  2. #2
    Linux Enthusiast
    Join Date
    Apr 2004
    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,

    To be good, you must first be bad. "Newbie" is a rank, not a slight.

  3. #3

    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?

  4. $spacer_open
  5. #4
    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.


Posting Permissions

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