Re: Rights required to run myisamcheck

Dan Nelson wrote: In the last episode (Jun 24), Jim Shea said: I'm setting up a cron job to run myisamcheck with the options "-Aacmorv". As I have to put in a username and password, for security I http://dev.mysql.com/doc/mysql/en/GRANT.html lists the available priv

Rights required to run myisamcheck

I'm setting up a cron job to run myisamcheck with the options "-Aacmorv". As I have to put in a username and password, for security I want to create a special account that has the minimum required rights. In searching the docs I don't find this listed. http://dev.mysql.com/doc/mysql/en/GRANT.ht

Re: Minimum privileges required for mysqldump

At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote: Give the use the lock option if you plan on using the --opt. How is that different than > Giving the "lock tables" permission as in: > grant select, lock tables on dbname.* to [EMAIL PROTECTED]; > results in the same mysqldump error. in the previous

Re: Minimum privileges required for mysqldump

On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Minimum privileges required for mysqldump: > I want to create a user that has the minimum rights to dump a database. I > can't find a discussion of the minimum required rights in the MySQL docs. At 2/27/2004

Minimum privileges required for mysqldump

I want to create a user that has the minimum rights to dump a database. I can't find a discussion of the minimum required rights in the MySQL docs. Included in my searching was: 5.4.3 Privileges Provided by MySQL and 8.7 mysqldump, Dumping T