mysqlcheck user minimum privileges

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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysqlcheck user minimum privileges

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=gcdmg-mysql-2@m.gmane.org