$ sudo apt-get update
$ sudo apt-get install mysql-server
$ vi /etc/mysql/conf.d/mysql.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

$ vi /etc/mysql/mysql.conf.d/mysqld.cnf

[mysql]
skip-networking = Off
bind-address            = 0.0.0.0 // 모든 ip에 대해서 mysql 접근 허용

$ systemctl start mysql
$ mysql -u root -p

CREATE DATABASE vocalist;
USE vocalist;
CREATE TABLE music(musicId int PRIMARY KEY auto_increment, title varchar(30) NOT NULL, artist varchar(20) NOT NULL);
DESC music; // 테이블 조회

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '(password)'; // 모든 ip에 대해서 데이터베이스 접근 허용