Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
vi /etc/yum.repos.d/MariaDB.repo  입력

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

위에 내용 입력 후 저장
yum install -y MariaDB MariaDB-server MariaDB-client


#서비스 시작은 설정완료후
service mariadb start

#setting for admin account
mysql_secure_installation


#test
mysql -u root -p
MariaDB [(none)]> show databases


 #부팅시 자동시작
systemctl enable mariadb.service

reflink : https://blog.bypass.sh/243 

주요설정

No Format
/etc/my.cnf 
[mysqld]
# Connection and Thread variables
port                           = 3306
socket                         = /var/run/mysqld/mysql.sock          # Use mysqld.sock on Ubuntu, conflicts with AppArmor otherwise
basedir                        = /usr
datadir                        = /data/mysql
tmpdir                         = /tmp
character_set_server           = utf8
collation_server               = utf8_general_ci


# dir set
chown -R mysql:mysql /data/mysql 

...