MySQL User privileges

[emu7]

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.

[Infopro]

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

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?

[emu7]

No, i created the user through phpmyadmin from root in WHM, as it is for an application on a seprate server.

[ludditetech]

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.

[cPanelDavidG]

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.

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

[david510]

No, i created the user through phpmyadmin from root in WHM, as it is for an application on a seprate server.

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";

[robertjmoore]

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