Maria DB (Ubuntu)

#mariadb 설치
sudo apt install mariadb-server mariadb-client -y

#위치 확인
ls /etc/mysql

#설치 확인
sudo systemctl status mariadb
mariadb --version

#재실행 / 등록
sudo systemctl start mariadb
or
sudo systemctl restart mariadb
sudo systemctl enable mariadb

#설정
sudo mysql-secure-installation
or
sudo mariadb-secure-installation

#로그인/권한 설정
sudo mariadb -uroot -p

CREATE USER 'admin_user'@'localhost' IDENTIFIED BY 'secret_password';
GRANT ALL PRIVILEGES ON *.* TO 'admin_user'@'localhost';

CREATE USER 'admin_user'@'%' IDENTIFIED BY 'secret_password';
GRANT ALL PRIVILEGES ON *.* TO 'admin_user'@'%';
FLUSH PRIVILEGES;
EXIT;

#외부 접속 허용
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
## bind-address = 127.0.0.1  //주석처리
port=3306