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 Forgetting User Permissions

Discussion in 'General Discussion' started by leighj, Jul 12, 2006.

  1. leighj

    leighj Well-Known Member

    Joined:
    Feb 21, 2003
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    From time to time MySQL 'forgets' users permissions... resulting in sites that use the database to go down...

    I'm using WHM 10.8.0 cPanel 10.8.2-C118 and MySQL 4.0.27 (NO 4.1 yet... not willing to take the risk)

    It's not a global forget just one or two here and there from time to time... and often weeks or months of quiet working.

    A grant and flush is what it takes to fix it (just the flush doesn't work)

    This is true for both cpanel created databases and users and non-cpanel MySQL users and databases.

    Any Hints?
     
  2. shykoty

    shykoty Member

    Joined:
    Dec 20, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Nashik
    me too

    Me too having the same problem, how can this be avoided....

    The mysql grant changes by itself
     
  3. aquariumtap

    aquariumtap Registered

    Joined:
    Jun 18, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Same problem here

    I'm also having this problem. Specifically the "lock table" and "create temporary table" permissions are removed.

    If it's relevant, which I hope it's not, I created the MySQL user and granted it permissions through PHPMyAdmin.
     
  4. Nikoms

    Nikoms Member

    Joined:
    Nov 29, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Same problem for me... but it always forget the permission...
     
  5. leighj

    leighj Well-Known Member

    Joined:
    Feb 21, 2003
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Possible Cause

    I THINK I may have found the source at least for my issue.

    I have a database that I created OUTSIDE of cPanel (there are reason for this) but it does seem to work from a database created by cPanel
    I then assigned permissions to a user whose username is ALSO that of a DIFFERENT account.
    Then an update or modification to the databases via cPanel happened.

    It looks like there is a grant process that goes through and removes permssions from the mysql users that are the cPanel account holders and then applies the permissions in the cPanel permssions list.

    I guess the reason for this is so that account security can't accidentally grant incorrect permissions. I got around this by creating a user on the cPanel account that has the database for the other and then using that INSTEAD of the second account user.
     
  6. itwebteam

    itwebteam Member

    Joined:
    Jul 7, 2004
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    yes, I have the same issue on a server: an app uses triggers and from time to time, mysql throws an "no permissions" error - this is extremely annoying.
     
  7. pcsteve

    pcsteve Registered

    Joined:
    Jun 10, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    #7 pcsteve, Jul 3, 2007
    Last edited: Jul 3, 2007
Loading...

Share This Page