1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Database access error after every update of MySQL

Discussion in 'Plesk 11.x for Linux' started by FrantišekH, Feb 4, 2013.

  1. FrantišekH

    FrantišekH New Pleskian

    16
    60%
    Joined:
    Sep 13, 2010
    Messages:
    21
    Likes Received:
    0
    Hi.
    Everytime when Plesk updates MySQL (three times a year?), one (always the same) user is unable to access his database. I have to remove him (via phpMyAdmin) and add him back, with all the same parameters, and it works. May be that restart of mysql daemon or flushing privileges will help, I did not tried yet. All other users work without problems.

    But why that user stop working after every MySQL update?

    CentOS 5.9, Plesk 11.0.9 Update #35


    Thank you.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,557
    Likes Received:
    1,242
    Location:
    Novosibirsk, Russia
    Plesk absolutely did not affect anything during MySQL packages update. So, check this behaviour on MySQL level.
     
  3. FrantišekH

    FrantišekH New Pleskian

    16
    60%
    Joined:
    Sep 13, 2010
    Messages:
    21
    Likes Received:
    0
    I am not sure. The only difference I see between that one faulty MySQL login and all other working logins is that all sites except that one are in Plesk in one subscription (me, as an admin) and that faulty site is in the only other subscription.
     
  4. FrantišekH

    FrantišekH New Pleskian

    16
    60%
    Joined:
    Sep 13, 2010
    Messages:
    21
    Likes Received:
    0
    Other difference was that only this user has "GRANT" privilege on this faulty user name. I removed that privilege a we will see after next Plesk update ;o)
     
Loading...