From: walter harms
Date: December 6 2009 1:05pm
Subject: Re: mysqlcheck user minimum privileges
List-Archive: http://lists.mysql.com/mysql/219585
Message-Id: <4B1BAC22.8000704@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

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
> 
>