[Mysql] Database / user 생성 및 권한 부여

1. Database 생성

먼저 Database를 생성합니다.

mysql> create database junedb default character set utf8;
Query OK, 1 row affected (0.01 sec)

만든 DB를 확인하고 해당하는 DB를 선택합니다.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| junedb             |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use junedb
Database changed

삭제를 하고싶은 경우에는 drop 구문을 사용합니다.

mysql> drop database junedb;
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

---

 

2. user 생성 및 권한 부여

먼저 user를 생성하고 모든 권한을 줍니다. (저는 연습용이니까!)

이후 해당 계정으로 로그인!

mysql> create user 'june'@'%' identified by '1234';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on junedb.* to june@'%' identified by '1234';
Query OK, 0 rows affected, 1 warning (0.00 sec)

권한 상태를 확인해보면 다음과 같습니다.

mysql> show grants for june@'%';
+--------------------------------------------------+
| Grants for june@%                                |
+--------------------------------------------------+
| GRANT USAGE ON *.* TO 'june'@'%'                 |
| GRANT ALL PRIVILEGES ON `junedb`.* TO 'june'@'%' |
+--------------------------------------------------+
2 rows in set (0.00 sec)

마지막으로 Table을 생성해보면

mysql> create table test(
    -> id int primary key auto_increment,
    -> name varchar(32) not null,
    -> job varchar(32) not null,
    -> tel varchar(15) )
    -> default charset=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+------------------+
| Tables_in_junedb |
+------------------+
| test             |
+------------------+
1 row in set (0.01 sec)

잘 생성 되었습니다!

데이터를 넣고 select 해봅니다.

mysql> insert into test(name,job,tel) values('hong','student',01012345678);
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+----+------+---------+------------+
| id | name | job     | tel        |
+----+------+---------+------------+
|  1 | hong | student | 1012345678 |
+----+------+---------+------------+
1 row in set (0.00 sec)

---