mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES

I am able to loging properly and able to take full backup from SQLyog Tool but when i am trying to take backup from MySQL Enterprise Workbencg then getting error message.

mysqldump: Got error: 1044: Access denied for user 'myuserid'@'%' to database 'mydatabasename' when doing LOCK TABLES

Operation failed with exitcode 2

Running: mysqldump.exe --defaults-file="c:\users\myuserid\appdata\local\temp\tmpbygwm5.cnf" --max_allowed_packet=1G --host=myconnectionhostname --force=TRUE --user=myuserid --port=3306 --default-character-set=utf8 "databasename" "itembrand"

Operation failed with exitcode 2

Regards, Md H. A. Khan