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.

Mysql Privs getting removed.

Discussion in 'General Discussion' started by Guda, May 23, 2008.

  1. Guda

    Guda Member
    PartnerNOC

    Joined:
    Aug 16, 2001
    Messages:
    20
    Likes Received:
    1
    Trophy Points:
    1
    Every method we've tried to create MySQL database users
    results in the user losing two privileges every 24 hours - "Lock
    Tables" and "Create Temporary Tables". Most recently we created
    the user SUPER on host.domain.com and used the mysql CLI to grant priviliges
    as follows:

    GRANT ALL PRIVILEGES TO 'SUPER'@'host.domain.com' ON *.*
    IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;

    What we've seen from our error logs is that our DB users lose their Lock
    Tables and Create Temporary Tables every 24 hour period at about 09:28 on the
    server, which is 12:28pm California time I believe.
    Is their a cron job running on the servers every 24 hour period that is causing the MySQL database
    users to get their privileges modified.

    Is the a cpanel cron script running every 24 hour period around this time that could be causing this? This occurs on all Linux servers.
     
  2. procam

    procam Well-Known Member

    Joined:
    Nov 24, 2003
    Messages:
    123
    Likes Received:
    0
    Trophy Points:
    16
    This problem is still happening with alarming frequency in order to stop it we must disable cpanel auto updates its happening during the updates I have completed the cpanel support ticket thing about this and they deny that their updates are causing it but its now happening on a second unit and disabling auto updates stops the problem so I see no way possible that it isnt cpanel despite what their support staff is telling me and its the exact same problem you are having.
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What is (was) your ticket number?
     
  4. procam

    procam Well-Known Member

    Joined:
    Nov 24, 2003
    Messages:
    123
    Likes Received:
    0
    Trophy Points:
    16
    My bad I got my facts wrong ~ cpanel did fix this on one of our units for us and provided the fix to me in the ticket here it is this will stop the server from changing those user permissions

    touch /etc/securemysqldisable
     
Loading...

Share This Page