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 regarding 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 08:35 AM, [EMAIL PROTECTED] wrote: > >The user will need SELECT access to the table(s) in question. > grant select on dbname.* to [EMAIL PROTECTED]; > will allow a > mysqldump -ubackupuser -ppassword dbname > dbname.dump.sql > but coughs on the mysqldump option "--opt" > mysqldump -ubackupuser -ppassword --opt dbname > dbname.dump.sql > mysqldump: Got error: 1044: Access denied for user: '[EMAIL PROTECTED]' > to database 'dbname' when using LOCK TABLES > Giving the "lock tables" permission as in: > grant select, lock tables on dbname.* to [EMAIL PROTECTED]; > results in the same mysqldump error. > If it matters my server version: 4.0.18-max-nt > Thanks > Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
