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 mxxs
auth_log.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxs
auth_log_sys.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxs
auth_log_track.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxs
auth_log_ub.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxs
code_bs.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxs
bs_mall.* to mxxs@’%’ identified by ‘!@#‘;
grant all privileges on mxxs
msg_bs.* to mxxs@’%’ identified by ‘!@#_’;

可使用navicat测试登录。

文档更新时间: 2022-04-09 16:16   作者:admin