/*DB 생성*/ mysql> create database db_name; /*사용자 생성*/ mysql> create user user_name; /*사용자 비밀번호 설정*/ mysql> use mysql; mysql> use user; mysql> update user set password=password('user_name_pw') where user='user_name'; Query OK, 1 row affected (0.07 sec) /*사용자 DB 권한설정*/ mysql> GRANT ALL ON db_name To 'user_name'@'%'; Query OK, 0 rows affected (0.04 sec)