Reseller has to change password to access phpmyadmin

Jul 8, 2018
8
1
3
San Antonio
cPanel Access Level
Root Administrator
Hello,

I have a VPS running CLOUDLINUX 7.4 vmware and cpanel v74.0.10.
(I have root access to the server itself)

I have a reseller account who keeps having to change their password if they want to access PHPMyAdmin from the cpanel associated with their domain.

They will get an error: mysqli_connect(): (28000/1045): Access denied for user 'USRNAME'@'localhost' (using password: YES)

Once the password is changed, they can access it again.

This is the third password change.

Any ideas?
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,110
659
263
Houston
cPanel Access Level
DataCenter Provider
HI @elisethechemist

Is there by chance a reason code for the login failure? The first error is to be expected when it's denying access but in most cases you get something like "Undefined index: auth_type" or some other reasoning.

For example:
undefined_index.png

Also, can you confirm that once the user does update their password they're able to access MySQL with the newly changed password?

Thanks!
 
Jul 8, 2018
8
1
3
San Antonio
cPanel Access Level
Root Administrator
The user said that most of the errors were covered by a yellow loading box, so they couldn't pick out the specifics.
The user changed their password a few hours ago and have been able to login since!

However, we had to do this a month ago as well - and then a few weeks ago before that.

Sorry, I know that's not much to go on, but none of the other reseller accounts seem to have this issue.
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
8,110
659
263
Houston
cPanel Access Level
DataCenter Provider
Hi @elisethechemist

Since it's not routinely reproducible I'd like to see if it happens again if you could please open a ticket using the link in my signature? That way we can see the behavior as it is occurring. Once open if you'd like to, reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


Thanks!