Re: Minimum privileges required for mysqldump

;<<<<<<<<<<<<<<<< On 2/27/04, 1:40:46 PM, Paul DuBois <[EMAIL PROTECTED]> wrote regarding Re: Minimum privileges required for mysqldump: > At 11:37 -0800 2/27/04, Jim Shea wrote: > >At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote: > >

Re: Minimum privileges required for mysqldump

At 11:37 -0800 2/27/04, Jim Shea wrote: 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 th

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

Give the use the lock option if you plan on using the --opt. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/27/04, 12:02:34 PM, Jim Shea <[EMAIL PROTECTED]> wrote

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

Re: Minimum privileges required for mysqldump

The user will need SELECT access to the table(s) in question. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regar

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