The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can't Login To MySQL After Account Transfer

Discussion in 'General Discussion' started by ChildOTK, Aug 8, 2011.

  1. ChildOTK

    ChildOTK Member

    Joined:
    Aug 2, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Good Day,

    I am setting up our new server with a new hosting company. I proceeded this morning to transfer multiple accounts from our current server.

    It appears that everything has worked okay, I can login to the cpanel account, but when I try open phpMyAdmin to view mySQL databases, I cannot login with the account name and password.

    Has anybody else run into this issue? Any advice, please?

    Thank you!
     
  2. ChildOTK

    ChildOTK Member

    Joined:
    Aug 2, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Just to clarify:

    I can get in to phpMyAdmin through WHM, logged in as root.

    From the account side however, on port 2082, logging in as a user and doing phpMyAdmin that way, doesn't work.

    Thanks.
     
  3. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    447
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    This is default behavior, you need to have the user/pass as you cannot log in via root or reseller override.
     
  4. ChildOTK

    ChildOTK Member

    Joined:
    Aug 2, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Okay..I can login with its general cPanel account, but just not to SQL. Does this mean I have to go reset the SQL password for each transferred account? I guess thats not a train smash as I created a quick PHP script to connect to SQL using what I've used before on the current server and it appears to be working fine.
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    I would suggest changing the MySQL password for each account to the cPanel password if they aren't matching up right now. You could actually issue this in root SSH:

    Code:
    /scripts/mysqlpasswd username password
    Where username is the cPanel username and password is the cPanel password for that account.
     
Loading...

Share This Page