Re: mysqlcheck user minimum privileges

2009-12-06 Thread walter harms
I do know thw internals,
but i guess having select only would be enough if you drop the auto-repair 
feature.
a repair always requires changes (=write).
maybe you can use mysqlldump instead ?
re,
 wh

René Fournier schrieb:
 Just wondering what they are. I'd rather not use the MySQL root user for a 
 backup script, if I can get away with  MySQL user with reduced privileges, 
 for the following command:
 
 mysqlcheck -ao --auto-repair --all-databases -u someuserotherthanroot 
 -pPASSWORD
 
 ...Rene
 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



mysqlcheck user minimum privileges

2009-12-04 Thread René Fournier
Just wondering what they are. I'd rather not use the MySQL root user for a 
backup script, if I can get away with  MySQL user with reduced privileges, for 
the following command:

mysqlcheck -ao --auto-repair --all-databases -u someuserotherthanroot -pPASSWORD

...Rene


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org