Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    306
    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:
    306
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice