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!

mysql password keeps getting reset by itself after cpanel backup process?

Discussion in 'General Discussion' started by craigedmonds, Aug 17, 2012.

  1. craigedmonds

    craigedmonds Well-Known Member

    Joined:
    Oct 29, 2007
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Twitter:
    I have figured out that one particular web site on my server (which is running phpmyrealty) throws an error after cpanel backup is run.

    The error is as follows: Initialization Error Access denied for user 'bluefla'@'localhost' (using password: YES).

    This error is an indication that the username or password I am using is incorrect.

    If I go into cpanel and try and update the password it tells me the old password is not valid, so I go in, delete the user, add the user again and then next time cpanel runs the backup, the site throws an error.

    I have also tried adding different usernames and variations of passwords, and still no effect.

    I know 100% it happens when cpanel backup runs becasue I just ran /scripts/cpbackup --force in ssh, and two minutes later, site was throwing an error.

    On this server there is around 50 sites and no other site has this issue and I have a few servers and have never seen this issue before.

    Has anyone seen this issue and can anyone help me to figure it out?

    I did post a thread on mysql.com (MySQL :: mysql password keeps getting reset by itself?) but that was before I realised it was cpanel backup causing the issue.

    Any help from cpanel on this would be great.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 craigedmonds, Aug 17, 2012
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,606
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Re: mysql password keeps getting reset by itself after cpanel backup proces

    Hello Craig,

    Please submit a ticket to us about this issue. In the ticket, please ensure to provide the cPanel username and password as well as the current MySQL username and password being used by the script.

    Tickets can be submitted in WHM > Support Center > Contact cPanel or using the link in my signature. Please post the ticket number here afterward for tracking purposes.

    Basically, I have no idea what might be causing this and the only way I know where we can see if the cPanel backup is causing an issue would be via a ticket.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelTristan, Aug 17, 2012
  3. craigedmonds

    craigedmonds Well-Known Member

    Joined:
    Oct 29, 2007
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: mysql password keeps getting reset by itself after cpanel backup proces

    Hi cPanelTristan,

    Signup for ticket support, went to submit and got this error: 2012-08-20_16-47-36.png - CraigEdmonds's library

    - - - Updated - - -

    okay, I submitted as normal support ticket now: 3067810
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 craigedmonds, Aug 20, 2012
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,606
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Re: mysql password keeps getting reset by itself after cpanel backup proces

    Based on the ticket, it appears the issue was due to the account having been suspended at a point in the past. When it was unsuspended, it didn't fully unsuspend and so whenever backups occurred, the databases were unsuspended and then resuspended so the passwords were changed. That's why they weren't working.

    To resolve, the technical analyst re-suspended and then unsuspended the account again.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelTristan, Aug 21, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql password keeps
  1. postcd

    MySQL upgrade to v.5.6+ old style passwords cPanel - explanation

    postcd, Mar 24, 2019, in forum: Data Protection
    Replies:
    2
    Views:
    168
    cPanelLauren
    Mar 27, 2019
  2. postcd

    Generating MySQL 5.7 compatible (strong) password & discover old plaintext password?

    postcd, Mar 24, 2019, in forum: Database Discussion
    Replies:
    2
    Views:
    204
    cPanelLauren
    Mar 27, 2019
  3. vicos

    SOLVED [CPANEL-25785] phpMyAdmin won't connect if mysql user password has special char

    vicos, Jan 28, 2019, in forum: Database Discussion
    Replies:
    17
    Views:
    460
    cPanelLauren
    Feb 27, 2019
  4. MajorLancelot

    MySQL root password special characters

    MajorLancelot, Jan 21, 2019, in forum: Database Discussion
    Replies:
    3
    Views:
    276
    cPanelLauren
    Jan 24, 2019
  5. ronaldst

    SOLVED MySQL errors - password and plugin authentication specified

    ronaldst, Nov 7, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    369
    cPanelLauren
    Nov 9, 2018

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.
    Accept Learn More...
    Dismiss Notice