MySQL Forums :: Newbie :: User as a definer does not exist when using LOCK TABLES


Advanced Search

User as a definer does not exist when using LOCK TABLES
Posted by: hui lin ()
Date: November 15, 2010 02:24AM

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:
mysqlmysql
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 mysqldump: Got error: 1045: Access denied for user 'user1'@'' (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,
Wisdoliu

Options: ReplyQuote


Subject Written By Posted
User as a definer does not exist when using LOCK TABLES hui lin 11/15/2010 02:24AM
Re: User as a definer does not exist when using LOCK TABLES peter wang 11/15/2010 02:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.