What command to run to change lock permissions on a user

Discussion in 'MySQL' started by robby1995, Feb 17, 2015.

  1. #1
    Im trying to export a DB on amazons RDS but whenever i run the mysqldump command i get the error:
    mysqldump: Got error: 1044: Access denied for user 'ec2'@'%' to database ‘DB_name’ when using LOCK TABLES

    I dont know the right command to run in my mac terminal to change the lock permissions for the user.

    can someone please help.
     
    robby1995, Feb 17, 2015 IP