#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Tempe, AZ, USA
    Posts
    12
    Rep Power
    0
    unfortunately I have lost my Root password for MySQL - is there any way to recover without re-installing ?
    -Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Netherlands
    Posts
    77
    Rep Power
    16
    "is there any way to recover without re-installing ?"

    I'm sorry to say, but I hope not!

    Succes, Peter
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Herdon, VA, USA
    Posts
    1
    Rep Power
    0
    YES YOU CAN.....you have to stop and reload MYSQL and do....
    --skip-grant-tables
    This option causes the server not to use the privilege system at all. This gives everyone full access to all databases! (You can tell a running server to start using the grant tables again by executing mysqladmin reload.)

    This will let you change the root as a normal user, it is secure cuz only root should have acess to the process.

Similar Threads

  1. Lost MySQL Password.. kinda
    By England in forum MySQL Help
    Replies: 1
    Last Post: November 13th, 2003, 05:54 AM
  2. Replies: 3
    Last Post: September 29th, 2002, 06:48 PM
  3. Replies: 1
    Last Post: March 4th, 2002, 02:28 PM
  4. retrieve password stored in mysql by using PHP
    By springdrops in forum PHP Development
    Replies: 7
    Last Post: February 15th, 2002, 02:54 PM
  5. putting a password on root
    By pixote in forum MySQL Help
    Replies: 10
    Last Post: October 25th, 2001, 05:49 AM

IMN logo majestic logo threadwatch logo seochat tools logo