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 1045 (mysql)

Discussion in 'General Discussion' started by AlaskanWolf, Nov 25, 2001.

  1. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    Changed the mysql root pass, and getting quite a bit of errors (user side ERROR 1045: Access denied for user: \'root@localhost\' (Using password: YES) 0

    whm side:

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


    already checked the .my.cnf file and it matches the new password, any ideas as i have 500 customers screaming down my back
     
  2. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    Did you change it w/ the WHManager or did you change it from the command line? You should do it from the WHManager and then restart all CPanel 3 servers, and run the phpmyadminupdate (within cpanel/bin somewhere... don\'t remember exactly where)... that will update the include files for the user frontend that is within each user\'s cpanel.....


    Let me know.
     
  3. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    WHM screws up when you try change the root mysql pass, I have found a fix for this for any other hosts that might encounter such error

    step by step

    login via ssh

    run the commands as follows:

    killall mysqld
    safe_mysqld --skip-grant-tables &
    /usr/local/cpanel/startup

    Then login into WHM reset the MySQL root
    password.

    go back to ssh...

    killall mysqld
    /etc/rc.d/init.d/mysql start

    And that should fix it... =)
     
  4. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    Never once had a problem w/ that function.
    Thanks for the advice!

    Rock on chicago.
     
  5. bonnmac

    bonnmac Well-Known Member

    Joined:
    Apr 26, 2003
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    16
    Thank Goodness & Thank You!

    I'm so glad this post was here. It's almost 2 years old but it just got me out of a jam. Thanks a million!

    :)


    cPanel.net Support Ticket Number:
     
  6. toma1708

    toma1708 Active Member

    Joined:
    Aug 30, 2001
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Not working.

    I tried that and it didn't fixed the problem.

    WHM 6.4.2
    Cpanel 6.4.2-E85
    RedHat 7.3

    Any other ideas ?

    Thank you.

    Catalin

    cPanel.net Support Ticket Number:
     
  7. SS ToXiC

    SS ToXiC Member

    Joined:
    Jul 6, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    all you have to do is reload the mysql...


    once you change the mysql password, login to phpmyadmin and reload the mysql.

    cPanel.net Support Ticket Number:
     
  8. NiteStalker22

    NiteStalker22 Active Member

    Joined:
    May 13, 2002
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    I've only ever used the 'Reset MySQL Root Password' in Webfsck Manager.. or whatever.

    Then if you must.. edit the .....

    /usr/local/cpanel/3rdparty/phpMyAdmin/config.inc.php

    ..file with a new crypted password.

    It's rare for me to need to go that far though.. only really ever need to just reset it.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page