SOLVED phpMyAdmin AuthenticationCpanel.php Error

[psytanium]

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:

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

 

[cPanelMichael]

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.

 

[DennisMidjord]

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

 

[psytanium]

Thanks, solved

 

[cPanelMichael]

Hello,

I'm glad to see that helped. Thank you for sharing the outcome.

 

[Yassine Bouzaka]

Not working with me , i changed mysql password (WHM)

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

 

[cPanelMichael]

Not working with me , i changed mysql password (WHM)

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.

 

[Metro2]

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"

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!

 

[Aeon_Sydney]

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.

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.

 

[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.

Does a /home/$username/.my.cnf file exist for the affected account?

Thank you.

 

[Aeon_Sydney]

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​

 

[cPanelMichael]

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,

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.

 

[kalexan]

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?

 

[cPanelMichael]

Hello @kalexan,

I've seen this happen on systems where the MySQL version was manually downgraded using an unsupported method. Can you check and see if that's the case on the affected server? Here's a command you can use to check this:

egrep -B1 '^Version' /var/lib/mysql/`hostname`.err

Does the output show a version downgrade at any point in time?

Thank you.

 

[kalexan]

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​

 

[kalexan]

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

 

[cPanelMichael]

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

Hello @kalexan,

Can you confirm that allowed phpMyAdmin to be accessed on the original account affected by the issue? If not, can you let us know of any specific output in /usr/local/cpanel/logs/error_log or /var/lib/mysql/$hostname.err when the access attempt fails?

Thank you.

 

[kalexan]

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

 

[cPanelMichael]

Hi @kalexan,

Can you open a support ticket so we can take a closer look at the affected system to see what's happening? You can post the ticket number here and I'll link this thread to the ticket.

Thank you.

 

[kalexan]

Ticket created:# 10239551

Btw, pretty awesome support workflow!