From: Michael Dykman Date: October 19 2010 4:35pm Subject: Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES List-Archive: http://lists.mysql.com/mysql/223386 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 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 wro= te: > >> 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 =3D 'root' AND host =3D '%'; >> 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'@'> 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=3Dprajapatikc@stripped >> >> > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.