The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error attempting to reset MySQL Root Password...

Discussion in 'General Discussion' started by brianteeter, Apr 17, 2002.

  1. brianteeter

    brianteeter Well-Known Member

    Joined:
    Jan 6, 2002
    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    I'm not sure what the MySQL Root password is on this server, thus I tried to reset it. Here is the error message I get:

    ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user: 'root@localhost' (Using password: YES)'

    Password changed for root to xxxxxxxxx

    Clearly, I can't change it unless I know what it is already... Is there a way to reset this other than what is in the WHM?

    Thanks - Brian
     
  2. brianteeter

    brianteeter Well-Known Member

    Joined:
    Jan 6, 2002
    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    Answered my own question...

    Needed to change paths, but otherwise the following worked pretty well.

    Thanks - Brian


    How to Reset the Root password of MySQL

    1. /usr/local/mysql/bin/safe_mysqld --skip-grant-tables &

    2. /usr/local/mysql

    3. use mysql;

    4. update user set password = password('.......') where user = 'root' and host='localhost';

    5. Stop and Start the MySQL server.
     
Loading...

Share This Page