mysql赋予创建用户权限,mysql查看所有用户权限

创建用户'viewer',密码为'123456'CREATE USER 'viewer'@'%' IDENTIFIED BY '123456' 授予其查看视图的权限GRANT SELECT, SHOW VIEW ON `table`.`view` TO 'viewer'@'%'