mysqldump -uroot -pPasswd DBName >/home/lsf/DB_Backup.sql
报错,显示:
Got error: 1449: The user specified as a definer ('root'@'') does not exist when using LOCK TABLES
或者直接:the user specified as a definer ('root'@'') does not exist
解决办法:
给root用户再添加一个对全部host都有可以访问的权限:
mysql -uroot -pPasswd
mysql >grant all privileges on *.* to root@"%" identified by "Passwd";
mysql >flush privileges;
转载于:https://blog.51cto.com/151wqooo/1302777