MySQL Forgetting User Permissions

[leighj]

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?

 

[shykoty]

me too

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

The mysql grant changes by itself

 

[aquariumtap]

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.

 

[Nikoms]

Same problem for me... but it always forget the permission...

 

[leighj]

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.

 

[itwebteam]

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.

 

[pcsteve]

Having this same problem:
http://forums.cpanel.net/showthread.php?t=68312

Does anyone have any idea how to fix this?