mysql创建数据库，表，用户和用户权限设置

CREATE DATABASE IFNOT EXISTS unittestsite DEFAULT CHARACTER set utf8 COLLATE utf8_general_ci;

 

USE unittestsite;

 

CREATE USER'unittest_u001'@'localhost' IDENTIFIED BY 'unittest_u001';

 

GRANT USAGE ON *.*TO 'unittest_u001'@'localhost' IDENTIFIED BY 'unittest_u001' WITHMAX_QUERIES_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0MAX_USER_CONNECTIONS 0;

 

GRANT SELECT,INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATEVIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARYTABLES, LOCK TABLES, EVENT ON `unittestsite`.* TO 'unittest_u001'@'localhost';

 

GRANT GRANT OPTIONON `unittestsite`.* TO 'unittest_u001'@'localhost';

 

DROP TABLE IF EXISTS`division_tbl`;

CREATE TABLE `tbl` (

  `domain` varchar(32) NOT NULLCOMMENT '区域',

  `company_id` varchar(32) NOTNULL COMMENT '公司ID',

  `division_seq` int(10) NOT NULLCOMMENT '部署序列号',

  `update_id` varchar(32) NOT NULL COMMENT'更新ID',

  `update_date` datetime NOT NULL COMMENT'更新日',

  PRIMARY KEY(`domain`,`company_id`,`division_id`)

) ENGINE=InnoDBDEFAULT CHARSET=utf8;