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 use

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 Li