https://bamdule.tistory.com/59
nano /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
yum install MariaDB
rpm -qa | grep MariaDB
mariadb --version
https://wordpressxe.tistory.com/7
# rpm -qa (설치된 모든 패키지 확인)
# rpm -qa | grep 패키지명
systemctl start mariadb // 시작
systemctl stop mariadb // 종료
systemctl stop mariadb // 재시작
systemctl status mariadb // active(running) or inactive(dead)
/usr/bin/mysqladmin -u root password '비밀번호'
netstat -anp | grep 3306
nano /etc/my.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
systemctl restart mariadb
mysql -u root -p
Enter password: 설정한 비밀번호 입력
show variables like 'c%';
또는 status로 확인
systemctl enable mariadb
systemctl is-enabled mariadb // enable 확인
firewall-cmd --permanent --zone=public --add-port=3306/tcp
firewall-cmd --reload // 재시작
grant all privileges on*.* to 'root'@'%' identified by 'root비밀번호';
flush privileges;
CREATE DATABASE 데이터베이스명;
USE 데이터베이스명;
--- 아이디 및 패스워드 설정
CREATE USER '사용자명'@'%' IDENTIFIED BY '패스워드';
GRANT ALL ON 데이터베이스명.* TO '사용자명'@'%';
FLUSH PRIVILEGES;
참고. mysql에서는 아래와 같은 설정이 필요하다
ALTER USER '사용자명'@'%' IDENTIFIED WITH mysql_native_password BY '패스워드';
FLUSH PRIVILEGES;