MySQL dump calls LOCK TABLES before dumping the data (presumably to
prevent data modification halfway through the process).
LOCK TABLES has its own privilege (conveniently given the same name)
which your user account will have to be given in order to run a
mysqldump.
On Fri, 2009-05-01 at 15:49 +
Hi lists,
I have given select privileges to database tables. when i am taking
mysqldump remotely it's giving error.
[prajap...@beta2 prajapati]$ mysqldump --verbose -h 152.20.1.115 -u dip dip
states -pdip > state.sql
-- Connecting to 152.20.1.115...
mysqldump: Got error: 1044: Access denied for u
