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.

mysql.user table is not updated

Discussion in 'General Discussion' started by taalaibek, May 9, 2006.

  1. taalaibek

    taalaibek Registered

    Joined:
    May 8, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I have:
    WHM 10.8.0 cPanel 10.8.2-R73
    CentOS 4.3 i686 - WHM X v3.1.0

    I upgraded MySQL 4.0 to 4.1 through WHM control panel.

    After, I couldn't access as root to mysql (ERROR 1045 (28000): Access denied for user 'root'@'loclahost' (using password: YES))

    In the log file I found this:

    060505 17:19:33 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.18-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)

    Then i run command mysql_fix_privilege_tables. But again the same error: ERROR 1045 (28000)

    I googled but didn't find correct solution. Please help ..
     
  2. avijit

    avijit Well-Known Member

    Joined:
    Jul 26, 2004
    Messages:
    116
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Reset the mysql root password from the WHM and that should fix your issue.
     
  3. taalaibek

    taalaibek Registered

    Joined:
    May 8, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I did reset from the WHM but failed.

    I tried changing .my.cnf file also, removing "" in user="root" and password="pwd". This not helped also.

    Any other suggesstion?
     
  4. taalaibek

    taalaibek Registered

    Joined:
    May 8, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    i found the solution. it is here:



    Mysql gives error of access denied for root@localhost ?

    Make sure root pass is in /root/.my.cnf

    This is usually the first root pass the box was given once cpanel is installed.

    If it still does not work, you will need to reset the mysqld root pass.

    First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

    Then stop chkservd to keep it from interfering with mysqld while you work on it
    with /etc/rc.d/init.d/chkservd stop

    Start up mysqld , but, without the grant tables,

    mysqld --skip-grant-tables -u mysql &

    Then change the pass..

    mysql -u root mysql
    UPDATE user SET Password=PASSWORD('new_password') WHERE User='root';
    FLUSH PRIVILEGES;

    Now you just killall -9 mysqld and start it up normally with it's safe_mysqld
    script.
     
Loading...

Share This Page