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 #scriptuntukmengaktifkandatabase
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

3. Jalankan dan izinkan mariadb berjalan di startup.

systemctl start mariadb
systemctl enable mariadb

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] y
New password:  #masukkan password
Re-enter new password:  #masukkan password

Password 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;