Of course you know you did not delete root@localhost, just root @ '%'
which generally should not matter to mysqldump.
What I suspect is the issue here is that the database you are trying
to dump contains procedures/methods that were defined by a user while
logged in as root@'%'. If you recreate those procs as your database
user, this should correct.
- michael dykman
On Tue, Oct 19, 2010 at 8:40 AM, Krishna Chandra Prajapati
> Hi Pradhan,
> Obviously, it should fail. Since you have deleted the root user which is
> used by mysqldump for making connection to mysql server for taking backup
> On Tue, Oct 19, 2010 at 11:06 AM, Tanmay Pradhan <tanmay04@stripped> wrote:
>> I am using the following version of MySQL on my Mac OS X Server 10.5.8:
>> *** Ver 14.14 Distrib 5.4.1-beta, for apple-darwin9.5.0 (i386) using
>> readline 5.1 ***
>> In order to restrict root account login from localhost only, I did the
>> mysql> DELETE FROM user WHERE user = 'root' AND host = '%';
>> mysql> FLUSH PRIVILEGES;
>> After this,
>> mysqldump failed with the following error:
>> $ /usr/local/mysql/bin/mysqldump -h localhost -u root ABC_DATABASE >
>> mysqldump: Got error: 1449: The user specified as a definer
>> ('root'@'%') does not exist when using LOCK TABLES
>> Even following cmd failed:
>> $ /usr/local/mysql/bin/mysqldump -h host_name -u user1 -pxxxx
>> ABC_DATABASE > abc.dump
>> mysqldump: Got error: 1045: Access denied for user 'user1'@'<IP
>> Address>' (using password: YES) when using LOCK TABLES
>> Can anybody advise as how to make mysqldump work while restricting
>> root login access from localhost only?
>> Thanks for any help.
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
- michael dykman
May the Source be with you.