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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED phpMyAdmin AuthenticationCpanel.php Error

Discussion in 'Database Discussions' started by psytanium, Jan 17, 2018.

Tags:
  1. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hello,

    This error appear on every mouse click I do:

    Some errors have been detected on the server!
    Please look at the bottom of this window.

    and a lonf error message appear at the bottom of the page:

    Code:
    Warning in ./libraries/plugins/auth/AuthenticationCpanel.php#629
mysqli_connect(): (28000/1045): Access denied for user 'dynoatm'@'localhost' (using password: YES)

Backtrace

./libraries/plugins/auth/AuthenticationCpanel.php#629: mysqli_connect(
string ********,
string ********,
string ********,
string ********,
string ********,
)
./libraries/plugins/auth/AuthenticationCpanel.php#389: PMA\libraries\plugins\auth\AuthenticationCpanel::cp_mysql_auth_check(
string 'dynoatm',
string 'Arcache10-10-10',
)
./libraries/common.inc.php#667: PMA\libraries\plugins\auth\AuthenticationCpanel->authCheck()
./sql.php#18: require_once(./libraries/common.inc.php)
    Thanks for your support
     
    #1 psytanium, Jan 17, 2018
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    It's possible the cPanel and MySQL password for that account is out of sync. You can try resetting the cPanel password to see if that solves the issue:

    "WHM >> Password Modification"

    Otherwise, check to see if a /home/$username/.my.cnf file exists under this account. If so, remove it, or update the password in this file to match the cPanel account password (or vice-versa).

    Thank you.
     
    #2 cPanelMichael, Jan 18, 2018
    Metro2 likes this.
  3. DennisMidjord

    DennisMidjord Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    120
    Likes Received:
    7
    Trophy Points:
    18
    Location:
    Denmark
    cPanel Access Level:
    Root Administrator
    We had that exact error yesterday for just 1 account. Changing the password like @cPanelMichael suggests fixed the issue straight away.
     
    #3 DennisMidjord, Jan 18, 2018
    Metro2 likes this.
  4. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Thanks, solved :)
     
    #4 psytanium, Jan 19, 2018
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm glad to see that helped. Thank you for sharing the outcome.
     
    #5 cPanelMichael, Jan 19, 2018
  6. Yassine Bouzaka

    Yassine Bouzaka Registered

    Joined:
    Jan 19, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Morocco
    cPanel Access Level:
    Root Administrator
    Not working with me , i changed mysql password (WHM)

    HTML:
    Warning in ./libraries/plugins/auth/AuthenticationCpanel.php#629
 mysqli_connect(): (28000/1045): Access denied for user 'cpses_'@'localhost' (using password: YES)

Backtrace

./libraries/plugins/auth/AuthenticationCpanel.php#629: mysqli_connect(
string ********,
string ********,
string ********,
string ********,
string ********,
)
./libraries/plugins/auth/AuthenticationCpanel.php#389: PMA\libraries\plugins\auth\AuthenticationCpanel::cp_mysql_auth_check(
string 'cpses_tn8uz7uz1g',
string 'L2zxcxBPDoBNSQof2DHe3kcPdBF7yH47',
)
./libraries/common.inc.php#667: PMA\libraries\plugins\auth\AuthenticationCpanel->authCheck()
./index.php#20: require_once(./libraries/common.inc.php)
Notice in ./libraries/plugins/auth/AuthenticationCpanel.php#81
 Undefined index: auth_type

Backtrace

./libraries/common.inc.php#670: PMA\libraries\plugins\auth\AuthenticationCpanel->auth()
./index.php#20: require_once(./libraries/common.inc.php)
Notice in ./libraries/plugins/auth/AuthenticationCpanel.php#99
 Undefined index: charset

Backtrace

./libraries/common.inc.php#670: PMA\libraries\plugins\auth\AuthenticationCpanel->auth()
./index.php#20: require_once(./libraries/common.inc.php)
 Cookies required
     
    #6 Yassine Bouzaka, Jan 19, 2018
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Are you accessing phpMyAdmin through Web Host Mnaager, or through cPanel? If it's through cPanel, the password to change is the account password via "WHM >> Password Modification".

    Thank you.
     
    #7 cPanelMichael, Jan 19, 2018
  8. Metro2

    Metro2 Well-Known Member

    Joined:
    May 24, 2006
    Messages:
    401
    Likes Received:
    19
    Trophy Points:
    168
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    This works like a charm for me. Had a couple user accounts with the same issue in the OP, and simply doing WHM > Password Modification without even giving them a different cPanel password works. Just did one a few minutes ago, same password the user had before, and it immediately fixed the phpMyAdmin display for them.

    As far as why this happens (and only rarely and only with one or two accounts) - my guess is it's possibly due to so many server migrations (in my case) where the client has been with me to 12 years and during that time we've phased out old servers / migrated to new ones at least 6 times. I'm guessing that occasionally during the Transfer Account process after so many times something is bound to go out of sync, but that's just my speculation.

    Thank you @cPanelMichael!
     
    #8 Metro2, Feb 3, 2018
  9. Aeon_Sydney

    Aeon_Sydney Registered

    Joined:
    Feb 11, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NYC Area
    cPanel Access Level:
    Root Administrator
    I have the same problem and it works for a little bit. However the next day it is broken again until I reset the root MySQL password again and it will work again until the next day.
     
    #9 Aeon_Sydney, Feb 11, 2018
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Does a /home/$username/.my.cnf file exist for the affected account?

    Thank you.
     
    #10 cPanelMichael, Feb 12, 2018
  11. Aeon_Sydney

    Aeon_Sydney Registered

    Joined:
    Feb 11, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NYC Area
    cPanel Access Level:
    Root Administrator
    Yes, the file exists and is correct. I have to keep resetting the root MySQL password every day otherwise when accessing phpMyAdmin from WHM I get prompted for the username and password and below it says:

    mysqli_connect() expects parameter 5 to be long, string given
    Undefined index: auth_type    ​
     
    #11 Aeon_Sydney, Apr 24, 2018 at 12:23 PM
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Can you open a support ticket so we can take a closer look? Feel free to post the ticket number here once it's opened and we will update this thread with the outcome:

    How to Open a Technical Support Ticket - cPanel Knowledge Base - cPanel Documentation

    Thank you.
     
    #12 cPanelMichael, Apr 24, 2018 at 12:48 PM
(You must log in or sign up to post here.)
Loading...
Similar Threads - phpMyAdmin AuthenticationCpanel Error
  1. gildas

    Error during auto-login on phpmyadmin

    gildas, Apr 6, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    51
    cPanelMichael
    Apr 6, 2018
  2. sinai

    Hide Remote MySql server IP address in phpmyadmin

    sinai, Jan 30, 2018, in forum: Security
    Replies:
    5
    Views:
    210
    cPanelMichael
    Feb 13, 2018
  3. kwdamp

    PHP version for Mysql (phpmyadmin)

    kwdamp, Jan 23, 2018, in forum: Database Discussions
    Replies:
    5
    Views:
    399
    cPanelMichael
    Jan 25, 2018
  4. gabrielwaskito

    Phpmyadmin Database Is Not Shown Directly

    gabrielwaskito, Jan 9, 2018, in forum: Database Discussions
    Replies:
    1
    Views:
    237
    Infopro
    Jan 9, 2018
  5. ciao70

    SOLVED PMASA-2017-9 - XSRF/CSRF vulnerability in phpMyAdmin

    ciao70, Jan 2, 2018, in forum: Security
    Replies:
    4
    Views:
    888
    cPanelMichael
    Feb 13, 2018

Share This Page