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 User privileges

Discussion in 'Data Protection' started by emu7, Jul 25, 2009.

  1. emu7

    emu7 Registered

    Joined:
    Feb 19, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I have created users through mysql, that have all privileges, for an openx installation.

    Every so often, the Lock Tables and Create Temporary Tables privilege gets revoked from the user i have created for it.

    It doesn't seem to follow a specific pattern as to why it does this. I have posted in many places and people have directed me stating cpanel may be the cause of my problem.

    Has anyone else experienced this problem and have a fix for it?

    Those privileges are necessary for openx to run its statistics compiling script and it doesn't let the stats compile when those privileges are not there.
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,468
    Likes Received:
    196
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Just to be clear, you created the database and user thru the cPanel interface on the users acount and gave the user full permission to the DB?
     
  3. emu7

    emu7 Registered

    Joined:
    Feb 19, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    No, i created the user through phpmyadmin from root in WHM, as it is for an application on a seprate server.
     
  4. ludditetech

    ludditetech Registered

    Joined:
    Jul 28, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Same here

    Host upgraded Cpanel and my backup mysql user lost lock tables privliges.

    I created this user and granted privilages via ssh.

    Granted privilages again and all works again but this is my backup user and it is not good as the backups stopped running.
     
  5. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    If this issue occurs again, please let our technical analysts take a look at your server so we can determine what is causing this to happen: http://tickets.cPanel.net/submit
     
  6. david510

    david510 Well-Known Member

    Joined:
    Aug 22, 2004
    Messages:
    473
    Likes Received:
    0
    Trophy Points:
    16
    See if the grant tables are showing fine.

    get into mysql prompt from shell

    mysql

    from mysql prompt

    use mysql
    select * from user where User="mysql_username";
     
  7. robertjmoore

    robertjmoore Registered

    Joined:
    Aug 21, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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.

    Full writeup and code snippets here:
    MySQL “Lock Tables” Disappears: Privilege Revoked Automatically « The Metric System
     
Loading...

Share This Page