#mysql
mysql -u root -p
mysql> use mysql
mysql> alter user root@localhost identified \
-> with mysql_native_password by 'jj';
#Query OK, 0 rows affected (0.00 sec)
mysql> create user mysam@localhost identified \
-> with mysql_native_password by 'j';
#Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on samDB.* to mysam@localhost;
#Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
#Query OK, 0 rows affected (0.05 sec)
create database goldDB;
use goldDB;
show tables;
create table Man(
->name char(20),
->age int);
insert into Man valuse("손흥민", 32);
insert into Man valuse("이강인", 23);
select * from Man;
