ノートDwinar

Hidup tuh bercanda, yang serius cuma mati

Menu
  • Home
  • Admin Server
    • Debian
    • RedHat
    • Ubuntu
    • Zimbra
  • Blog
  • Buku & Publishing
  • About
  • Contact
Menu

Cara Instal dan Konfigurasi MariaDB di RedHat 7

Posted on August 2, 2018August 2, 2018 by dwinar

Pada tutorial kali ini akan membahas tentang cara menginstal MariaDB di RedHat 7. MariaDB sendiri digunakan sebagai database untuk web server. Ok langsung saja berikut adalah langkah – langkahnya adalah sebagai berikut :

# Install MariaDB

yum -y install mariadb-server php-mysql

Buka file konfigurasi MariaDB

nano /etc/my.cnf

Tambahkan character-set-server=utf8 seperti berikut

[mysqld]
character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Jalankan MariaDB

systemctl start mariadb
systemctl enable mariadb

# Konfigurasi Untuk MariaDB

mysql_secure_installation

Tekan Enter

Enter current password for root (enter for none):

Set root password

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!

Hapus anonymous users

Remove anonymous users? [Y/n] y
 ... Success!

Disallow root login remotely

Disallow root login remotely? [Y/n] y
 ... Success!

Hapus test database

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reload privilege tables

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

# Mengatur firewall untuk MariaDB

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

Demikian tutorian dari. Terimakasih telah membaca

1 thought on “Cara Instal dan Konfigurasi MariaDB di RedHat 7”

  1. Hmm says:
    February 2, 2019 at 2:31 pm

    Istighfar ea

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Instalasi T-Pot Honeypot Framework
  • Ulang Tahun Excellent 9
  • Cara Setting DNS over HTTPS
  • Cara Upgrade OS Mikrotik
  • Membersihkan Sampah Pada Docker

Recent Comments

  • dwinar on Cara Membuat VPS di Google Cloud Platform
  • Ilham on Cara Membuat VPS di Google Cloud Platform
  • dwinar on Cara Membuat Docker Private Registry
  • Sugeng Agung Suganda on Cara Membuat Docker Private Registry
  • Juan Carlos on Cara Install XAMPP di openSUSE 15.1

Categories

  • Admin Server
  • Blog
  • Debian
  • RedHat
  • Ubuntu
  • Zimbra

Archives

  • January 2021
  • September 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018

Tags

Authentication Blog CentOS Clamav Cockpit cPanel DataBases Debian DHCP DNS Server Docker Docker CE Excellent FTP google cloud Kubernetes Let’s Encrypt Linux lsync MariaDB Mikrotik Nakivo NextCloud Nginx Open Source OpenSUSE PHP Proxmox RedHat 7 Repo ROUTING S/MIME SSH SSL Swap Training Ubuntu Video Conference Web Server Wordpress Zextras Zimbra Zimbra Docs Zimbra Drive Zimbra NE
August 2018
MTWTFSS
 12345
6789101112
13141516171819
20212223242526
2728293031 
« Jul   Sep »
© 2021 ノートDwinar | Powered by Minimalist Blog WordPress Theme