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
Subject
Written By
Posted
User as a definer does not exist when using LOCK TABLES
November 15, 2010 02:24AM
November 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.