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'@'%';
时间:2021-05-12 04:45:18
create user '用户名'@'%' identified by '密码';
create user 'test'@'%' identified by '123';
GRANT SELECT ,show view on 视图名 to '用户名'@'%';
GRANT SELECT ,show view on test_view to 'test'@'%';