mysql 8.0.X linux ubuntu 20.04, 从一个mysql 数据库通过mysqldump导数据库到另一套Mysql, 导入成功, select * from tables.也成功, 但select * from view 就不功能了。 出错为: mysql 8.0error 1449 select from a view as a definer(‘mysqluser1'@'localhost') does not exist
查了网上的,没太成功, 一想, 就是缺少 mysqluser1 这个用户。就
create user 'mysqluser1'@'localhost' identified by 'new-pswd' ; # 密码不用和原数据上的用户密码相同,
grant all privileges on *.* to ' 'mysqluser1'@'localhost' with grant option;
flush privileges.
就行了。