Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Reseller has to change password to access phpmyadmin

Discussion in 'Database Discussion' started by elisethechemist, Nov 7, 2018.

  1. elisethechemist

    elisethechemist Member

    Joined:
    Jul 8, 2018
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,206
    Likes Received:
    478
    Trophy Points:
    233
    Location:
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. elisethechemist

    elisethechemist Member

    Joined:
    Jul 8, 2018
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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.
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,206
    Likes Received:
    478
    Trophy Points:
    233
    Location:
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. elisethechemist

    elisethechemist Member

    Joined:
    Jul 8, 2018
    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    San Antonio
    cPanel Access Level:
    Root Administrator
    Will do!
    Thank you very much.
     
    cPanelLauren likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice