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
>
>
