[MySQL] DB 생성 및 DB, User 권한 설정

DB 생성 및 DB, User 권한 설정

1. 새로운 DB 생성
ex) sagnchul_db 생성
> create database sangchul_db;

2. 새로운 DB의 생성과 소유자 및 권한 설정
ex) localhost, sangchul_db DB명, sangchul DB소유자
> INSERT INTO db ( Host , Db , User , Select_priv , Insert_priv , Update_priv , Delete_priv , Create_priv , Drop_priv , Grant_priv , References_priv , Index_priv , Alter_priv , Create_tmp_table_priv , Lock_tables_priv ) VALUES ('localhost', 'sangchul_db', 'sangchul', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

3. 새로운 사용자, 패스워드, 사용 권한 설정
ex) localhost, sangchul DB 소유자, sangchul001 DB패스워드
> INSERT INTO user ( Host , User , Password , Select_priv , Insert_priv , Update_priv , Delete_priv , Create_priv , Drop_priv , Reload_priv , Shutdown_priv , Process_priv , File_priv , Grant_priv , References_priv , Index_priv , Alter_priv , Show_db_priv , Super_priv , Create_tmp_table_priv , Lock_tables_priv , Execute_priv , Repl_slave_priv , Repl_client_priv , ssl_type , ssl_cipher , x509_issuer , x509_subject , max_questions , max_updates , max_connections ) VALUES ('localhost', 'sangchul', PASSWORD( 'sangchul001' ) , 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', '0', '0', '0');

4. 적용
> flush privileges;