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 '<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-red-color">admin_user'@'localhost</mark>' IDENTIFIED BY '<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-red-color">secret_password</mark>';
GRANT ALL PRIVILEGES ON *.* TO '<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-red-color">admin_user</mark>'@'localhost';

CREATE USER '<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-red-color">admin_user'@'%</mark>' IDENTIFIED BY '<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-red-color">secret_password</mark>';
GRANT ALL PRIVILEGES ON *.* TO '<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-red-color">admin_user</mark>'@'%';
FLUSH PRIVILEGES;
EXIT;

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