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!

problem after mysql update

Discussion in 'General Discussion' started by ramil, May 24, 2006.

  1. ramil

    ramil Active Member

    Joined:
    Dec 28, 2003
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    156
    Hi,

    after updating form 4 to 4.1 mysql works, but I am unable to login via phpmyadmin with error message Access denied for user 'root'@'localhost' (using password: YES)', and sites with php/mysql are not working, I already made changes on mysql root password, but no sucess...

    Regards
     
    #1 ramil, May 24, 2006
  2. inventor

    inventor Member

    Joined:
    May 14, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    hi,

    Can you check this case : Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)
     
    #2 inventor, May 24, 2006
  3. ramil

    ramil Active Member

    Joined:
    Dec 28, 2003
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    156
    yes, but no success..

    a mysqld is running, even a Horde! but there is a prblem with other sites with php+mysql, when trying to open sites, its loading for a long time, and when try command 'mysql', got an error:

    Access denied for user 'root'@localhost'....
     
    #3 ramil, May 24, 2006
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    Did you do what inventor suggested and added the old password directive in /etc/my.cnf?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 AndyReed, May 24, 2006
  5. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    29
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
    Adding

    old-passwords

    to the [mysqld] section in /etc/my.cnf

    and running /scripts/restartsrv_mysql

    should be effective

    If note

    try

    /scripts/mysqlconnectioncheck
     
    #5 cPanelNick, May 24, 2006
  6. ramil

    ramil Active Member

    Joined:
    Dec 28, 2003
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    156
    finally I did it! :)

    I have this problem after updating cpanel to latest stable version...

    If you are running a latest stable version of cpanel and FedoraCore 4, dont run upcp with mysql upgrading, the versions of mysql 4.0.26, 4.0.27, 4.1.x are not running properly, you will get a lot of errors like:
    - no pid file found...
    - no sock file found...
    - user mysql not found...
    - access denied for user 'root@localhost'
    - or if Mysql 4.1.x is running but you have a high server loads etc.

    just do the following (downgrading to Mysql 4.0.23):

    1. Remove mysql from your system
    yum remove mysql *
    2. go to http://updates.cpanel.net/mysqlinstall/i386/ and download all rpm files except Mysql-bench
    3. Run 'rpm -Uvh MySQL-*.rpm --force'
    4. Run 'service mysql start' or '/scripts/restartsrv_mysql'

    Thats all ;)
     
    #6 ramil, May 24, 2006
  7. kemis

    kemis Well-Known Member

    Joined:
    Feb 17, 2005
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Georgetown, TX
    As I search the threads, I see that others are now having this exact same problem lately (including myself!). So it seems to me this is something bigger than a single user with a misconfiguration problem.

    I have cpupdate disabled, but evidently the "System Software" update still runs automatically. Well, last night I got auto-updated to 4.1.19. Since then, I also have Web sites that get the access is denied error, and cpbackup itself can't backup the mysql databases because of the same access is denied problem!

    I verified that I do have the "old-passwords = 1" option in my /etc/my.cnf (but I set this through WHM --> Tweak Settings). I also restarted the service using /scripts/restartsrv_mysql but it didn't help. Finally, /scripts/mysqlconnectioncheck simply returned me to the prompt with no output. Is this normal?

    Anyway, I just wanted to say I'm in this boat, too, now. Does anyone know why the autoupdate caused these problems? Is cPanel doing anything about it? I guess I can go poke around their bugzilla db. I'll go do that now...

    -- Matt
     
    #7 kemis, Jun 1, 2006
  8. kemis

    kemis Well-Known Member

    Joined:
    Feb 17, 2005
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Georgetown, TX
    Fixed my own problem, too, Ramil! I did it by simply going to WHM --> Change a User or Database Password and resetting my mysql root password back to my usual.

    All is well again, I believe.

    -- Matt
     
    #8 kemis, Jun 1, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - problem mysql update
  1. trucmuche

    permission problem since MySQL 5.6.37 update

    trucmuche, Sep 1, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    498
    cPanelMichael
    Oct 27, 2017
  2. geokat

    Problem after mysql root password change

    geokat, May 17, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    297
    cPanelLauren
    Jul 16, 2018 at 10:10 AM
  3. jaheem

    Problem mysql restart in whm

    jaheem, Nov 3, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    865
    cPanelMichael
    Nov 3, 2017
  4. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    553
    cPanelMichael
    May 4, 2017
  5. lifesecond

    Problem with Remote mysql

    lifesecond, Mar 4, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    1,231
    cPanelMichael
    Mar 6, 2017

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.
    Accept Learn More...
    Dismiss Notice