SOLVED phpMyAdmin AuthenticationCpanel.php Error

We had that exact error yesterday for just 1 account. Changing the password like @cPanelMichael suggests fixed the issue straight away.

 

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

 

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!

 

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.

 

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​

 

Hello
At a CENTOS 6.10 standard server with cPanel v 74.0.6, I tried to use PhpMyAdmin at one of my accounts through cpanel, however phpmyadmin refuses with errors:

mysqli_connect(): (28000/1045): Access denied for user 'accountusername'@'localhost' (using password: YES)
Undefined index: auth_type
Undefined index: charset

I changed the account 's password from WHM, I got the result message that MySQL password was updated, however, I still cannot log in using cpanel (still the same error appears). I do not have specific .my.cnf at that account. I have no problem logging in to phpMyAdmin from WHM (root user), however I thing that PhpMyAdmin and cPanel/WHM are somewhat "out of sync", so if I will change root password, I will not be able to login at any database using PhpMyAdmin.

Any thoughts?

 

Hi @cPanelMichael

No, all versions are in ascending order:

Line 1: Version: '5.1.73-cll
Line 5: Version: '5.1.73-cll
Line 8: Version: '5.1.73-cll
Line 11: Version: '5.1.73-cll
Line 14: Version: '5.1.73-cll
Line 17: Version: '5.1.73-cll
Line 20: Version: '5.5.42-cll
Line 23: Version: '5.5.42-cll
Line 26: Version: '5.5.42-cll
Line 29: Version: '5.5.42-cll
Line 32: Version: '5.5.42-cll
Line 35: Version: '5.5.42-cll
Line 38: Version: '5.5.42-cll
Line 41: Version: '5.5.45-cll
Line 44: Version: '5.5.45-cll
Line 47: Version: '5.5.46-cll
Line 50: Version: '5.5.46-cll
Line 53: Version: '5.5.47-cll
Line 56: Version: '5.5.47-cll
Line 59: Version: '5.5.48-cll
Line 62: Version: '5.5.48-cll
Line 65: Version: '5.5.49-cll
Line 68: Version: '5.5.49-cll
Line 71: Version: '5.5.50-cll
Line 74: Version: '5.5.50-cll
Line 77: Version: '5.5.50-cll
Line 80: Version: '5.5.50-cll
Line 83: Version: '5.5.50-cll
Line 86: Version: '5.5.52-cll
Line 89: Version: '5.5.52-cll
Line 92: Version: '5.5.52-cll
Line 95: Version: '5.5.52-cll
Line 98: Version: '5.5.54-cll
Line 101: Version: '5.5.54-cll
Line 104: Version: '5.5.54-cll
Line 107: Version: '5.5.54-cll
Line 110: Version: '5.5.55-cll
Line 113: Version: '5.5.55-cll
Line 116: Version: '5.5.57-cll
Line 119: Version: '5.5.57-cll
Line 122: Version: '5.5.57-cll
Line 125: Version: '5.5.58-cll
Line 128: Version: '5.5.58-cll
Line 131: Version: '5.5.58-cll
Line 134: Version: '5.5.58-cll
Line 137: Version: '5.5.58-cll
Line 140: Version: '5.5.58-cll
Line 143: Version: '5.5.59-cll
Line 146: Version: '5.5.59-cll
Line 149: Version: '5.5.59-cll
Line 152: Version: '5.5.59-cll
Line 155: Version: '5.5.59-cll
Line 158: Version: '5.5.59-cll
Line 161: Version: '5.5.60-cll
Line 164: Version: '5.5.60-cll
Line 167: Version: '5.5.60-cll​

 

Just an update: I changed the account password from an other account at the same server, and I did not have problem logging in through cPanel and then PhpMyAdmin

 

Sorry I was not clear enough: I changed the account password FOR an other account at the same server, and I did not have any problems logging in through cPanel and then PhpMyAdmin for this account. The original account that had the problem is still affected

I checked
/usr/local/cpanel/logs/error_log
and
/var/lib/mysql/$hostname.err
for entries around the time of login, nothing was logged

 

Ticket created:# 10239551

Btw, pretty awesome support workflow!