MySQL创建用户并赋予某个视图权限

1、创建用户

create user '用户名'@'%' identified by '密码';

create user 'test'@'%' identified by '123';

2、赋予视图权限

GRANT SELECT ,show view on 视图名 to '用户名'@'%';

GRANT SELECT ,show view on test_view to 'test'@'%';