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.

Cannot use phpMyAdmin - Access denied

Discussion in 'Database Discussions' started by Biotron2000, Jan 25, 2007.

  1. Biotron2000

    Biotron2000 Active Member

    Joined:
    Jul 20, 2004
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    6
    I get this when trying to use phpMyAdmin, either as root or any site user:

    Access denied
    Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
    Error

    MySQL said: Documentation
    #1045 - Access denied for user: 'root@localhost' (Using password: NO)
    phpMyAdmin was unable to read your configuration file!
    This might happen if PHP finds a parse error in it or PHP cannot find the file.
    Please call the configuration file directly using the link below and read the PHP error message(s) that you receive. In most cases a quote or a semicolon is missing somewhere.
    If you receive a blank page, everything is fine.

    ./config.inc.php


    I checked the config.inc.php file, it was modified at 10:35 last night, the same time frame the cPanel Update ran.


    Any ideas out there?


    Thanks,
    Patrick McNeal
     
  2. Henric

    Henric Member

    Joined:
    Feb 27, 2006
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Maybe because of the cpanel update. Seems you are using cpanel current version

    I had this problem in my servers

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

    vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php +62

    Make sure your 62nd line is like this

    $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
     
    #2 Henric, Jan 25, 2007
    Last edited: Jan 25, 2007
  3. ee99ee

    ee99ee Well-Known Member

    Joined:
    Aug 15, 2003
    Messages:
    70
    Likes Received:
    0
    Trophy Points:
    6
    Fixed my issue. Thank you!
     
  4. faze

    faze Registered

    Joined:
    Jun 10, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I've noticed this issue on 3 different servers while at work.

    perhaps the cPanel repository has an uh oh in the config.inc.php?

    it always seems to be the same incorrect characters:
    $cfg['Servers'][$i]['host'] = 'localhost$2 // MySQL hostname or IP address

    where it should be
    $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address

    -James J
     
  5. Biotron2000

    Biotron2000 Active Member

    Joined:
    Jul 20, 2004
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for the replies!
    It turned out to be the line 62 issue ($2 instead of '; ). That did the trick.
    Thanks again,
    Patrick McNeal
     
  6. FC5_Slut

    FC5_Slut Member

    Joined:
    Sep 29, 2006
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Great to see a lot of Beta Testers out there :P
     
  7. mfpoulsen

    mfpoulsen Registered

    Joined:
    Nov 15, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thank you, Henric. This solved our problem too.
     
  8. blweb

    blweb Active Member

    Joined:
    Oct 1, 2004
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for the help, solved my problem on all my boxes as well... when the update was applied is when it broke.. Thanks again!

     
  9. biggdogg285

    biggdogg285 Well-Known Member

    Joined:
    May 14, 2004
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Nothing here has resolved my problem. My localhost line is correct in the confic.inc.php

    Some users can't access phpMyAdmin from their cPanel. I already did a /scripts/upcp --force, and that didn't fix anything.

    Any help would be appreciated!
     
  10. tooxic

    tooxic Member

    Joined:
    Sep 16, 2005
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    This has happened again on my server and nothing has resolved it...
     
Loading...

Share This Page