Of course you know you did not delete r...@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 <prajapat...@gmail.com> wrote: > 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 > > Krishna > CGI.COM > > > > On Tue, Oct 19, 2010 at 11:06 AM, Tanmay Pradhan <tanma...@gmail.com> wrote: > >> Hi, >> >> 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 >> following: >> 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 > >> abc.dump >> 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. >> >> Regards, >> Tanmay >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com >> >> > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org