[ mysql ] CentOS 7 mysql MariaDB 실행 / 설정 / 방화벽 / 계정생성 > database

# systemctl enable mariadb.service

# firewall-cmd --permanent --zone=public --add-port={80,3306}/tcp

# firewall-cmd --reload

# systemctl restart firewalld

# firewall-cmd --list-all

# systemctl status mariadb

# systemctl start mariadb

# systemctl enable mariadb

# mysql -u root

# use mysql

# update user set password = password('12345') where user = 'root'

# mysql -u root -p

# create database <database_name> character set UTF8mb4 collate utf8mb4_unicode_ci

# show databases

# use DB_NAME

# drop database DB_NAME

# mysql -u root -p

# use mysql

+ 계정생성 택1

# create user '<userid>'@'localhost' identified by 'passwd' : 내부에서만 접근가능

# create user '<userid>'@'%' identified by 'passwd' : 어디서든지 접근가능

# create user '<userid>'@'192.168.0.%' identified by 'passwd' : 192.168.0.xxx 접근가능

+ 권한 설정

# grant all privileges on <database_name>.* to userid@'%'