phpMyAdmin AuthenticationCpanel.php Error
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:
Thanks for your support
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
-
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. 0 -
We had that exact error yesterday for just 1 account. Changing the password like @cPanelMichael suggests fixed the issue straight away. 0 -
Thanks, solved :) 0 -
Hello, I'm glad to see that helped. Thank you for sharing the outcome. 0 -
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[/HTML] 0 -
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.0 -
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!0 -
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.0 -
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.0 -
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_type0 -
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.0 -
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? 0 -
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.0 -
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 0 -
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 0 -
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.0 -
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 :( 0 -
Ticket created:# 10239551 Btw, pretty awesome support workflow! 0 -
Hello, To update, here's the response from the support ticket noting the solution: You should now be able to access phpmyadmin when logging into the 'user123' account when using the password again. In order to get this working, I ended up manually setting the password for the 'user123' through mysql: ===== set password for 'user123'@'localhost' = PASSWORD(' [ PASSWORDHERE ] '); flush privileges; ===== After doing this, I verified that I could access phpmyadmin when logging into the 'user123' cPanel account using the password. Then, I changed the password for this account and verified I could access phpmyadmin when logging in using the new password. Finally, I switched the 'user123' back to the original password and verified that I could still access phpmyadmin when logging into the 'user123' cPanel account using the password. Thank you,
Thank you.0 -
I just changed a password of Cpanel and it worked for me, Thank you so much. 0 -
Just in case this is helpful / relevant to others... just a couple of notes regarding some user accounts unable to load phpMyAdmin from cPanel: I had previously thought that maybe this issue stemmed from accounts being migrated from old server to new server (as I mentioned in my previous post on first page of this thread) but - have since discovered that it seems to happen randomly / to random accounts occasionally, regardless of whether they were migrated from an existing previous account / server or if they've been created within past year on same server. There was a time when I could resolve this by just updating the DB User password for a DB in cPanel (even using the same password) for example - on a WordPress site I could examine wp-config.php and copy the password from it, go to their cPanel > Databases > DB Users and use the change password function and just re-enter same password and Save, and that would fixed it. But that method hasn't worked in a long time. The only thing that consistently resolves this issue is changing their actual cPanel password. (I do it though WHM > Account Functions because it's convenient, but it can be done in SSH command line of course). I can't seem to determine any pattern or reason as to why it happens. It's very random. Could have 200 accounts on a server and randomly this will happen with just a couple of accounts here & there. Sporadic. Thankfully the easy fix is to just change their cPanel password. This no big deal to us of course, but for some users you'd think it was the end of the world having to tell them their cPanel password has been updated ;) 0 -
First of all, thank you for sharing a couple of solutions and a little bit of info as to why this issue occurs. The first solution, which is to change the password using the "WHM>Password Modification" method, did not work for me. The second solution, which is to directly change the MySQL password for the cpanel user worked for me. But the question still remains: Why did this happen? Also, for this particular user where the problem occurred there is still an issue. Yes, it works when I change the MySQL password using shell, but when I then again try to change the cpanel password using the "WHM>Password Modification" method, it won't synchronize. Thank you very much! -Jeremy 0 -
am seriuosly experiencing the same problem, I have tried all solutions but database still not connecting. I need an urgent help. 0 -
so how did you fix it? 0 -
@sozuadavi2 - have you tried resetting the cPanel user's password from WHM? 0 -
I ran into this today too. I tried a number of fixes and luckily I noticed another user was able to login via other accounts on their server but not one or two... I also found that to be the case. I tried changing the password to the account with no luck... then I tried changing the password of the user with privileges to the database and no luck.... and then I tried again to change the password for the account... then it worked. For me, it seemed to be a combination of both password resets to make it work. 0
Please sign in to leave a comment.
Comments
27 comments