Project_AWS_07_MySQL Workbench_사용자 생성하기

1. 사용자 생성하기

CREATE USER  '계정 이름'@'%' IDENTIFIED BY '비밀번호';

 

2. 권한 부여하기(모든 권한)

 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO '계정 이름'@'%' WITH GRANT OPTION;

 

3. 즉시 적용하기

FLUSH PRIVILEGES;

 

4. 커밋하기

COMMIT;

CREATE USER 'team2'@'%' identified by 'team2222';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, 
	PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, 
    CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, 
    REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, 
    ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'team2'@'%' WITH GRANT OPTION;

CREATE USER 'teamtwo'@'%' identified by 'team2222';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, 
	PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, 
    CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, 
    REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, 
    ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'teamtwo'@'%' WITH GRANT OPTION;

flush privileges;
commit;