MySQL dump error: The user specified as a definer does not exist when using LOCK TABLES

The user specified as a definer does not exist when using LOCK TABLES

We need to create the missing user specfied in the definer ans assign the privileges to resolve this issue.

>grant all privileges on db.* to user@host identified by 'pass';

Here,

db need to be replaced with the name of the database.
user need to be replaced with the user specfied in the definer.
host need to be replaced with the MySQL host.
pass need to be replaced with the passsword required for the user.

Now we will be able to take the mysqldump without any issues.

That's all…