Install Mariadb 10.4 di CentOS 7

Dalam penginstalan CentOS 7 with GUI dan MariaDB Database Server sudah terinstall di dalamnya dengan Mysql/MariaDB Server version: 5.5.60-MariaDB MariaDB Server

Buat MariaDB Yum Repository

Buat file repository

vi /etc/yum.repos.d/MariaDB.repo

Tambahkan baris berikut ke dalam MariaDB.repo di terminal anda

[mariadb]
name = MariaDB
baseurl = https://download.nus.edu.sg/mirror/mariadb/yum/10.4/centos/$releasever/$basearch
module_hotfixes = 1
gpgkey = https://download.nus.edu.sg/mirror/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1

Atau download file MariaDB.repo dan copy paste file tersebut ke directory /etc/yum.repos.d

Install MariaDB di CentOS 7

Jalankan perintah berikut untuk memulai install MariaDB

sudo yum install MariaDB-server MariaDB-client

Setelah install selesai, start dan enable service database server

systemctl start mariadb

systemctl enable mariadb

systemctl status mariadb

Secure MariaDB CentOS 7

mariadb-secure-installation

secure mariadb di centos 7

Menjalankan MariaDB di CentOS 7

Jalankan service MySQL

systemctl enable mariadb

systemctl start mariadb

Buat User Remote

Masuk ke dalam shell MariaDB, dengan perintah berikut

mariadb

Selanjutnya buat user remote

MariaDB [(none)]>

create user 'root'@'%' identified by 'password';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;