1、创建数据库:
create database mxxs_auth_bo;
create database mxxs_auth_log;
create database mxxs_auth_log_sys;
create database mxxs_auth_log_op
create database mxxs_auth_log_track
create database mxxs_auth_log_ub;
create database mxxs_code_bs;
create database mxxs_bs_mall;
create database mxxs_msg_bs;
2、创建用户:
create user ‘mxxs‘@’localhost’ identified by ‘!@#‘;
create user ‘mxxs‘@’%’ identified by ‘!@#‘;
备注:localhost本机ip,%任何ip
3、配置权限:
grant all privileges on mxxs_auth_bo.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxsauth_log.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxsauth_log_sys.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxsauth_log_track.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxsauth_log_ub.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxscode_bs.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxsbs_mall.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxsmsg_bs.* to mxxs@’%’ identified by ‘!@#_’;
可使用navicat测试登录。