Skip to content Skip to sidebar Skip to footer

RHEL 7 Database Server 1 : Install Mariadb database server

Assalamu’alaykum warahmatullah wabarakatuh,,

Kali ini saya akan share mariadb di rhel7. Cukup sederhana, anda harus menginstall repo lokal terlebih dahulu. Cari aja tutor gw di web. Lanjut, kita akan coba share ilmunyahh…

Lalu coba kita install mariadb nyahh

1. install mariadb nya.

yum -y install mariadb-server




2. Kita edit pada bagian konfigurasi mariadb nya.

nano /etc/my.cnf
[mysqld]character-set-server=utf8 #scriptuntukmengaktifkandatabasedatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0

3. Jalankan dan izinkan mariadb berjalan di startup.

4. Kita konfigurasi mariadb nya.

mysql_secure_installation
Enter current password for root (enter for none): [enter]OK, successfully used password, moving on...Set root password? [Y/n] yNew password:  #masukkan passwordRe-enter new password:  #masukkan passwordPassword updated successfully!Reloading privilege tables.. ... Success!Remove anonymous users? [Y/n] y ... Success!Disallow root login remotely? [Y/n] y ... Success!Remove test database and access to it? [Y/n] y - Dropping test database... ... Success! - Removing privileges on test database... ... Success!Reload privilege tables now? [Y/n] y ... Success!

5. Kasih jejelin dia ke firewall.

firewall-cmd –add-service=mysql –permanent
firewall-cmd –reload


6. Kita coba login.

mysql -u root -p
MariaDB [(none)]> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema |+--------------------+3 rows in set (0.00 sec)MariaDB [(none)]> show databases;

Post a Comment for "RHEL 7 Database Server 1 : Install Mariadb database server"