List:General Discussion« Previous MessageNext Message »
From:walter harms Date:December 6 2009 1:05pm
Subject:Re: mysqlcheck user minimum privileges
View as plain text  
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 ?

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
mysqlcheck user minimum privilegesRenĂ© Fournier5 Dec
  • Re: mysqlcheck user minimum privilegeswalter harms6 Dec