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 user loses lock tables privilege every day

Discussion in 'General Discussion' started by veronicabend, Dec 18, 2008.

  1. veronicabend

    veronicabend Well-Known Member

    Joined:
    Feb 25, 2005
    Messages:
    63
    Likes Received:
    1
    Trophy Points:
    158
    Hi,

    I have manually created a mysql user which doesn't belong to any cpanel account on server. This is a global user which I use for a script that runs daily and does mysqldump of all databases. I created this user by accessing PhpMyAdmin from within WHM, then clicked on Privileges link on first screen there, and added the user. This user only has these privileges:

    select
    show databases
    lock tables

    Every day, I need to go back and manually add the lock tables privilege because it is gone. after I add it, my backup script runs just fine. Then next day when it runs automatically, it sends me an error message. I go look, and the user has lost the lock tables privilege.

    There must be some process in cron removing this privilege.

    Please help me see how I can have this user keep its privileges. Right now my automatic database backup script is useless with this issue. Thanks.
     
    #1 veronicabend, Dec 18, 2008
  2. dballanc

    dballanc Registered

    Joined:
    Dec 29, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    I'm having the same problem.

    I'm also experiencing this. It's maddening. The only way I've been able to work around so far is by using the root password, which is just slightly less unacceptable than having a failing backup script.

    Any information on how to fix the issue correctly would be greatly appreciated.
     
    #2 dballanc, Mar 14, 2009
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    This is done by /scripts/securemysql, which is executed during cPanel updates. To prevent this from happening, perform the following from the command line:

    Code:
    # touch /etc/securemysqldisable
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelKenneth, Mar 16, 2009
  4. Ivanner

    Ivanner Active Member

    Joined:
    Oct 13, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    151
    Tried this and the user still loses its privileges. His privileges get rolled back to "USAGE"
     
    #4 Ivanner, Mar 18, 2009
    Last edited: Mar 18, 2009
  5. AlexAT

    AlexAT Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2003
    Messages:
    203
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Ukraine
    cPanel Access Level:
    Root Administrator
    For a month I get this problem for different users.
    cPanel support can't help me with it.

    I'll try this command "touch /etc/securemysqldisable" and will see how it goes.
    But customers angry, wery angry.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 AlexAT, Mar 25, 2009
  6. AlexAT

    AlexAT Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2003
    Messages:
    203
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Ukraine
    cPanel Access Level:
    Root Administrator
    Currently I have several customers complain about thos problem.
    So this fix (touch /etc/securemysqldisable) does not help.

    Any ideas?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 AlexAT, Apr 1, 2009
  7. jacampbe

    jacampbe Active Member

    Joined:
    Mar 19, 2008
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    56
    I have found that the cPanel backup job only resets the mySQL privileges for cPanal accounts - ie. those accounts associated with a cPanel domain.
    To avoid this problem use a non-cPanel mySQL account with global privileges (SELECT, LOCK TABLES).
    It works for me.
     
    #7 jacampbe, Apr 6, 2009
  8. robertjmoore

    robertjmoore Registered

    Joined:
    Aug 21, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    some options for resolving this

    I bumped into this issue yesterday and traced it back through the cPanel update script (and the scripts it calls).

    It looks like some options for fixing this are:
    • touch the securemysqldisable file
    • remove the 'removelockntmp' parameter from the securemysql call in mysqlup
    • restore the MySQL privileges daily by inserting mysql calls into postcpup.

    - Removed -
     
    #8 robertjmoore, Aug 21, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL user loses
  1. Maning

    limit user connections on mysql

    Maning, Oct 11, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    52
    cPanelLauren
    Oct 12, 2018 at 1:04 PM
  2. ca2236

    Question on mysql and usernames

    ca2236, Sep 7, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    73
    cPanelMichael
    Sep 11, 2018
  3. Bert de Jong

    Change MySQL User Password in WHM Issue

    Bert de Jong, Sep 6, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    102
    cPanelLauren
    Sep 11, 2018
  4. planetjoin

    SOLVED MySQL usernames with no underscore?

    planetjoin, Aug 22, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    104
    cPanelLauren
    Aug 23, 2018
  5. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    164
    cPanelMichael
    Jul 16, 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