upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

[agd85]

i use ZRM to do backups of my databases.

with v5.1.x, this works fine,

  mysql-zrm-scheduler --now --backup-set manual --backup-level 0

to execute a manual backup.

i recently upgraded from v5.1.x -> v5.5.12,

 mysqladmin -V
  mysqladmin  Ver 8.42 Distrib 5.5.12, for Linux on i686

now, at exec of that backup cmd, i see an ERROR @ console,

        ...
        manual:backup:INFO: PHASE START: Creating raw backup
        manual:backup:INFO: Command used for raw backup is
        /usr/share/mysql-zrm/plugins/socket-copy.pl
        --mysqlhotcopy=/usr/bin --host="localhost" --port="3306"
        --socket="/var/cache/mysql/mysql.sock" --quiet  mysql 
        "/var/mysql-bkup/manual/20110605131003" >
        /var/cache/tmp/bZvaQFwQY2 2>&1
        manual:backup:INFO: raw-databases=mysql
        manual:backup:INFO: PHASE END: Creating raw backup
        manual:backup:INFO: PHASE START: Creating logical backup
        manual:backup:WARNING: The database(s) drupal6
        performance_schema will be backed up in logical mode since they
        contain tables that use a transactional engine.
        manual:backup:INFO: Command used for logical backup is
        "/usr/bin"/mysqldump --opt --extended-insert --create-options
        --default-character-set=utf8 --routines --host="localhost"
        --port="3306" --socket="/var/cache/mysql/mysql.sock" --databases
        drupal6 performance_schema  >
        "/var/mysql-bkup/manual/20110605131003/backup.sql"
        mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to
        user 'root'@'localhost' for table 'cond_instances' when using
        LOCK TABLES
-->     manual:backup:ERROR: mysqldump did not succeed.
         Command used is "/usr/bin"/mysqldump --opt --extended-insert
         --create-options --default-character-set=utf8 --routines
         --host="localhost" --port="3306"
         --socket="/var/cache/mysql/mysql.sock" --databases drupal6
         performance_schema  >
         "/var/mysql-bkup/manual/20110605131003/backup.sql"manual:backup:INFO:
         PHASE START: Cleanup
        manual:backup:INFO: backup-status=Backup failed
        ...


reading up on the error at,

 http://bugs.mysql.com/bug.php?id=33762
 http://bugs.mysql.com/bug.php?id=49633

it looks to do with mysqldump itself.  i modified in /etc/my.cnf

        ...
        [mysqldump]
        quick
        quote-names
        max_allowed_packet = 8M
+       skip-lock-tables
        ...

but that doesn't seem to make any difference.

something's changed between 5.1.x & 5.5.x.

what do i need to modify to get past this error?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org