用户创建及赋权

创建用户

create user zcbus identified by '******';

用户赋权

GRANT SELECT, SHOW VIEW, SHOW DATABASES ON *.* TO zcbus;

权限查询

show grants for zcbus;