[ Server ][ Linux ] CentOS 7 mysql MariaDB 실행 / 설정 / 방화벽 > linux

# systemctl status mysql

# systemctl start mysql

# 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