Install dan konfigurasi data base server (MariaDB)

 1. setelah masuk dan login jangan lupa masukkan perinta su untuk superuser dan masukkan password

2. sudo dnf install mariadb-server -y

3. mariadb --version

4. sudo systemctl enable mariadb

5. sudo systemctl status mariadb

6. sudo systemctl status mysql

CTRL + X

CTRL+ C

7. sudo systemctl restart mysql

sudo systemctl status mysql

8. sudo journalctl -xe

CTRL + X

CTRL + C

9. sudo tail -n 30 /var/log/mysql/error.log

sudo find / -type s -name "mysql.sock" 2>/dev/null/var/lib/mysql/mysql.sock

mysql -u root -p --socket=/tmp/mysql.sock

masukkan password

10. sudo mysql_secure_installation

Enter current password for root (enter for none): masukkan password 

Switch to unix_socket authentication [Y/n] : yes

Change the root password? [Y/n] yes

Remove anonymous users? [Y/n] yes

Disallow root login remotely? [Y/n] yes

Reload privilege tables now? [Y/n] yes

11. mysql -u root -p

masukkan password

MariaDB [ (none) ]> create database wordpress;

MariaDB [ (none) ]> CREATE USER 'Putridb'@'localhost' IDENTIFIED BY 'jaringan';

MariaDB [ (none) ]> grant all privileges on *.* to 'Putridb'@'localhost';

MariaDB [ (none) ]> exit

12. firewall-cmd --permanent --add-port=3306/tcp

firewall-cmd --reload

systemctl restart mariadb

systemctl status mariadb

13. nano setup_db.sql

-- Membuat database bernama sekolah 

CREATE DATABASE sekolah;

-- Membuat user bernama siswa dengan password 'jaringan'

CREATE USER 'siswa'@'localhost' IDENTIFIED BY 'jaringan';

-- Memberikan hak akses penuh ke database sekolah

 GRANT ALL PRIVILEGES ON sekolah.* TO 'siswa'@'localhost';

-- Terapkan perubahan

FLUSH PRIVILEGES;

14. selanjutkan masukkan perintah "sudo mysql -u root -p < setup_db.sql" untuk menjalankan semua peritah SQL dalam file setup_db.sql secara otomatis, setelah itu masukkan password yang telah dibuat sebelumnya

15. masukkan perintah "sudo mysql -u root -p", lalu masukkan password yang telah dibuat sebelumnya.

MariaDB [ (none) ]> SHOW DATABASES;

MariaDB [ (none) ]> SELECT user, host FROM mysql.user;

MariaDB [ (none) ]> exit