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