HELPPPPPPPP MYSQL

Discussion in 'General' started by cowboy47, Aug 10, 2007.

  1. cowboy47

    Joined:
    Jun 14, 2007
    Messages:
    276
    Likes Received:
    0
    OK, How I did this, I have no clue but I managed to change the root password in mysql. I have spent hours going through the web trying to find ways of repairing this but all to no avail. I need some sort of guidance on how to repair this issue or if I do a reinstall, how to recreate the databases, without having to do a complete reinstall of the 0.8.4 system.

    C

    :blush:
     
  2. cowboy47

    Joined:
    Jun 14, 2007
    Messages:
    276
    Likes Received:
    0
    BIG BUMP. Please somebody give me a hand.
     
  3. bogus

    Joined:
    Jul 8, 2007
    Messages:
    5
    Likes Received:
    0
    Hi,

    may be you try this:

    How to Reset a MySQL Password in 5 Easy Steps

    1. Stop the mysqld daemon process.
    2. Start the mysqld daemon process with the --skip-grant-tables option.
    3. Start the mysql client with the -u root option.
    4. Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
    5. Execute the FLUSH PRIVILEGES; command.

    These steps reset the password for the "root" account to "password". To change the password for a different account, or to set a different password, just edit the variables in single-quotes in step 4.

    If you know your existing MySQL root password, steps 1-3 are not necessary.

    found at www.tech-faq.com
     
  4. dbbrito

    Joined:
    Jul 22, 2007
    Messages:
    12
    Likes Received:
    0
    I did not understand the steps, can explain me better
     
  5. cowboy47

    Joined:
    Jun 14, 2007
    Messages:
    276
    Likes Received:
    0
    Thanks, that helps. Unfortunately in my case, the root user password was unknown because of fat fingering it. So, I ended up having to do a complete reinstall.

    I strongly recommend that everyone install webmin & make a backup of all your sql databases.

    C
     

Share This Page