List:General Discussion« Previous MessageNext Message »
From:Tanmay Pradhan Date:October 19 2010 5:36am
Subject:mysqldump: Got error: 1449: The user specified as a definer
('root'@'%') does not exist when using LOCK TABLES
View as plain text  
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
Thread
mysqldump: Got error: 1449: The user specified as a definer('root'@'%') does not exist when using LOCK TABLESTanmay Pradhan19 Oct
  • Re: mysqldump: Got error: 1449: The user specified as a definer('root'@'%') does not exist when using LOCK TABLESKrishna Chandra Prajapati19 Oct
    • Re: mysqldump: Got error: 1449: The user specified as a definer('root'@'%') does not exist when using LOCK TABLESMichael Dykman19 Oct
      • Re: mysqldump: Got error: 1449: The user specified as a definer('root'@'%') does not exist when using LOCK TABLESTanmay Pradhan20 Oct
        • Re: mysqldump: Got error: 1449: The user specified as a definer('root'@'%') does not exist when using LOCK TABLESTanmay Pradhan21 Oct
    • Re: mysqldump: Got error: 1449: The user specified as a definer ('root'@'%')does not exist when using LOCK TABLESMySQL)20 Oct