1.2.5、初始化数据库

请联系开发人员，提供初始化数据库脚本！

# 数据库管理账号
revoke all privileges on *.* from 'ty_admin'@'%';
grant all privileges on ty_admin.* to 'ty_admin'@'%' identified by 'cMeYp2kj3MLandYX';
grant all privileges on mysql.* to 'ty_admin'@'%' identified by 'cMeYp2kj3MLandYX';
grant usage on *.* to 'ty_admin'@'%';
SHOW GRANTS FOR 'ty_admin'@'%';

# 魔方对接数据库
revoke all privileges on *.* from 'ty_mofang'@'%';
grant all privileges on ty_mofang.* to 'ty_mofang'@'%' identified by 'cMeYp2kj3MLandYX';
grant all privileges on mysql.* to 'ty_mofang'@'%' identified by 'cMeYp2kj3MLandYX';
grant usage on *.* to 'ty_mofang'@'%';
SHOW GRANTS FOR 'ty_mofang'@'%';

# 综合评价
revoke all privileges on *.* from 'ty_evaluation'@'%';
grant all privileges on ty_evaluation.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant all privileges on ty_evaluation_dashboard.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant all privileges on ty_evaluation_pretank.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant all privileges on ty_admin.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant all privileges on ty_auth.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant all privileges on xxl_job_e8n.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant all privileges on mysql.* to 'ty_evaluation'@'%' identified by 'dJ2yPsZDfrjNPLjb';
grant usage on *.* to 'ty_evaluation'@'%';
SHOW GRANTS FOR 'ty_evaluation'@'%';


revoke all privileges on *.* from 'ty_bmp'@'%';
grant all privileges on bmp_admin_isv.* to 'ty_bmp'@'%' identified by 'cMeYp2kj3MLandYX';
grant all privileges on mysql.* to 'ty_bmp'@'%' identified by 'cMeYp2kj3MLandYX';
grant usage on *.* to 'ty_bmp'@'%';
SHOW GRANTS FOR 'ty_bmp'@'%';

revoke all privileges on *.* from ty_portfolio@'%';
grant all privileges on ty_portfolio.* to 'ty_portfolio'@'%' identified by 'e8EGHcKNTYkKx7bb';
grant all privileges on mysql.* to 'ty_portfolio'@'%' identified by 'e8EGHcKNTYkKx7bb';
grant usage on *.* to 'ty_portfolio'@'%';
SHOW GRANTS FOR 'ty_portfolio'@'%';

revoke all privileges on *.* from 'nacos'@'%';
grant all privileges on nacos.* to 'nacos'@'%' identified by 'ktLiW3kkFF7dBkEB';
grant all privileges on mysql.* to 'nacos'@'%' identified by 'ktLiW3kkFF7dBkEB';
grant usage on *.* to 'nacos'@'%';
SHOW GRANTS FOR 'nacos'@'%';

revoke all privileges on *.* from 'xxl_job'@'%';
grant all privileges on nacos.* to 'xxl_job'@'%' identified by 'cMeYp2zj6MLandYX';
grant all privileges on mysql.* to 'xxl_job'@'%' identified by 'cMeYp2zj6MLandYX';
grant usage on *.* to 'xxl_job'@'%';
SHOW GRANTS FOR 'xxl_job'@'%';