Hi,
I have manually created a mysql user which doesn't belong to any cpanel account on server. This is a global user which I use for a script that runs daily and does mysqldump of all databases. I created this user by accessing PhpMyAdmin from within WHM, then clicked on Privileges link on first screen there, and added the user. This user only has these privileges:
select
show databases
lock tables
Every day, I need to go back and manually add the lock tables privilege because it is gone. after I add it, my backup script runs just fine. Then next day when it runs automatically, it sends me an error message. I go look, and the user has lost the lock tables privilege.
There must be some process in cron removing this privilege.
Please help me see how I can have this user keep its privileges. Right now my automatic database backup script is useless with this issue. Thanks.
I have manually created a mysql user which doesn't belong to any cpanel account on server. This is a global user which I use for a script that runs daily and does mysqldump of all databases. I created this user by accessing PhpMyAdmin from within WHM, then clicked on Privileges link on first screen there, and added the user. This user only has these privileges:
select
show databases
lock tables
Every day, I need to go back and manually add the lock tables privilege because it is gone. after I add it, my backup script runs just fine. Then next day when it runs automatically, it sends me an error message. I go look, and the user has lost the lock tables privilege.
There must be some process in cron removing this privilege.
Please help me see how I can have this user keep its privileges. Right now my automatic database backup script is useless with this issue. Thanks.