I had a case where I had read only permissions for mysql server however I had to do dump and would get:
Access denied for user ''@'%' to database 'comdb_production' when doing LOCK TABLES
To overcome that I used—skip-lock-table:
mysqldump --skip-lock-tables -u root -p db_dev users > users.sql