创建用户 赋予权限

create user ‘cxjk_xsuser’@’%’ identified by ‘.Cxjk_2832’;

GRANT SELECT ON cxjk.t_employee to ‘cxjk_xsuser’@’%’;
GRANT SELECT ON cxjk.t_department to ‘cxjk_xsuser’@’%’;

create user ‘msp_safeuser’@’%’ identified by ‘Cloud@mklis9562cz2’;
GRANT ALL ON cxjk_xspt.* TO ‘msp_safeuser’@’%’;
GRANT SELECT ON mysql.proc TO ‘msp_safeuser’@’%’;

grant execute on procedure cxjk_xspt.* to ‘msp_safeuser’@’%’;
grant execute on function cxjk_xspt.* to ‘msp_safeuser’@’%’;

create user ‘msp_queryuser’@’%’ identified by ‘Cloud@mklis9562cz3’;
GRANT SELECT ON cxjk_xspt.* TO ‘msp_queryuser’@’%’;

set password for 用户名@localhost = password(‘新密码’);

flush privileges;