MySQL User Adding Process
1. 현재 User 확인
SELECT User, Host, authentication_string FROM mysql.user;
+------------------+-----------+------------------------------------------------------------------------+
| User | Host | authentication_string |
+------------------+-----------+------------------------------------------------------------------------+
| debian-sys-maint | localhost | $A$005$| "BkIj*1K/dxU"ocZe2NkQQ6LXQcezz.x3rksu0tfbuuapaKTkLEgv7km5 |
| mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root | localhost | |
+------------------+-----------+------------------------------------------------------------------------+
5 rows in set (0.00 sec)
2. User 추가
create user '사용사이름'@'%' identified by '비밀번호';
grant all privileges on *.* to `jisoo`@`%`;
flush privileges;
3. New DB 추가
show databases; # 현재 DB 확인
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
use test; # 사용할 schema 선택
# Reading table information for completion of table and column names
# You can turn off this feature to get a quicker startup with -A
# Database changed
INSERT into test (id, kkk) values (1, "hello");
# test DB의 id 및 kkk열에 1, hello 값을 넣음 
:)