Create Users:
CREATE USER
'coupang'
@
'localhost'
IDENTIFIED BY
'test'
;
CREATE USER
'winter'
@
'localhost'
IDENTIFIED BY
'test'
;
CREATE USER
'summer'
@
'localhost'
IDENTIFIED BY
'test'
;
Create databases:
CREATE DATABASE `fds` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE DATABASE `ods` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
Grant Permissions:
USE mysql;
INSERT INTO db (HOST, Db, USER, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Index_priv, Alter_priv)
VALUES(
'localhost'
,
'fds'
,
'coupang'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST, Db, USER, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Index_priv, Alter_priv)
VALUES(
'localhost'
,
'ods'
,
'coupang'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'localhost'
,
'fds'
,
'winter'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'10.%.%.%'
,
'fds'
,
'winter'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'localhost'
,
'fds'
,
'summer'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'N'
,
'N'
,
'N'
,
'N'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'10.%.%.%'
,
'fds'
,
'summer'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'N'
,
'N'
,
'N'
,
'N'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'localhost'
,
'ods'
,
'winter'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'10.%.%.%'
,
'ods'
,
'winter'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'localhost'
,
'ods'
,
'summer'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
INSERT INTO db (HOST,Db,USER,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Index_priv, Alter_priv)
VALUES(
'10.%.%.%'
,
'ods'
,
'summer'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
,
'Y'
);
FLUSH PRIVILEGES;