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 +0530, Krishna Chandra Prajapati wrote:
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 user 'dip'@'152.20.1.%' to
database 'dip' when doing LOCK TABLES
Thanks,
Krishna Chandra Prajapati
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org