SOLVED phpMyAdmin AuthenticationCpanel.php Error

psytanium

Well-Known Member
Jun 6, 2014
183
8
18
Lebanon
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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.
 
  • Like
Reactions: Metro2

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello,

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

Yassine Bouzaka

Registered
Jan 19, 2018
1
0
1
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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

Well-Known Member
May 24, 2006
455
41
178
USA
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"
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

Registered
Feb 11, 2018
2
0
1
NYC Area
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.
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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

Registered
Feb 11, 2018
2
0
1
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.
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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

Member
PartnerNOC
Jul 28, 2005
11
1
153
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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:

Code:
egrep -B1 '^Version' /var/lib/mysql/`hostname`.err
Does the output show a version downgrade at any point in time?

Thank you.
 

kalexan

Member
PartnerNOC
Jul 28, 2005
11
1
153
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

Member
PartnerNOC
Jul 28, 2005
11
1
153
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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

Member
PartnerNOC
Jul 28, 2005
11
1
153
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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.