[Ubuntu 20.04] MariaDB 11.3.2 설치

1. MariaDB Server 다운로드

DB 버전 : 11.3.2 Community Server

https://mariadb.org/download/?t=mariadb&p=mariadb&r=11.3.2&os=Linux&cpu=x86_64&pkg=tar_gz&i=systemd&m=blendbyte

Download MariaDB Server - MariaDB.org

 

 

2. 설치

groupadd mysql
useradd -g mysql mysql
 cp mariadb-11.3.2-linux-systemd-x86_64.tar.gz /usr/local/mariadb-11.3.2-linux-systemd-x86_64.tar.gz

cd /usr/local
tar -zxvpf mariadb-11.3.2-linux-systemd-x86_64.tar.gz
ln -s mariadb-11.3.2-linux-systemd-x86_64 mysql
cd mysql
./scripts/mariadb-install-db --user=mysql
chown -R root .
chown -R mysql data

 

3. 환경 변수 추가

vi ~/.bashrc
export PATH=$PATH:/usr/local/mysql/bin/
source ~/.bashrc

 

 

4. 자동 실행

cp support-files/mysql.server /etc/init.d/mysql.server

cp support-files/systemd/mariadb.service /usr/lib/systemd/system/mariadb.service

mkdir /etc/systemd/system/mariadb.service.d/

cat > /etc/systemd/system/mariadb.service.d/datadir.conf <<EOF
[Service]
ReadWritePaths=/usr/local/mysql/data
EOF

systemctl daemon-reload

systemctl start mariadb.service

systemctl enable mariadb.service

 

 

 

에러 

#1 mariadb: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

$sudo ln -s /usr/lib/x86_64-linux-gnu/libncursesw.so.6.2 /usr/lib/x86_64-linux-gnu/libncursesw.so.5

$ sudo ln -s /usr/lib/x86_64-linux-gnu/libncurses.so.6.2 /usr/lib/x86_64-linux-gnu/libncurses.so.5

$ sudo ln -s /usr/lib/x86_64-linux-gnu/libncursesw.so.6.2 /usr/lib/x86_64-linux-gnu/libtinfo.so.5

참고 : https://mariadb.com/kb/en/installing-mariadb-binary-tarballs/