Does Cpanel change mysql user priviledge automatcially by some rules?

J

jusfeel

Registered
Mar 2, 2008
3
0
51
Beijing
Hi,

I am using Cpanel. One Cpanel account is backup. I use it to backup my database.

Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'.

I gave "lock table' priviledge again and run the script, it is ok.

But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again.
I wonder if Cpanel is messing me up? What can I do about it? anyone knows?


James
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
D SOLVED CPANEL-40284 - SQL configuration on cpanel 102+ query_cache_type configuration does not stick Databases 3
vicos Does cPanel install mySQL or mariaDB by default? Databases 8
K How does cPanel handle username conflicts in MySQL? Databases 4
Z Does cPanel Support MySQL 8? Databases 5
Bigwebmaster SOLVED [CPANEL-20407] chkservd restarts MySQL when server time doesn't match MySQL time Databases 8
Similar threads
SOLVED CPANEL-40284 - SQL configuration on cpanel 102+ query_cache_type configuration does not stick
Does cPanel install mySQL or mariaDB by default?
How does cPanel handle username conflicts in MySQL?
Does cPanel Support MySQL 8?
SOLVED [CPANEL-20407] chkservd restarts MySQL when server time doesn't match MySQL time
Top Bottom