Instalasi MariaDB pada Debian¶

sudo apt-get install dirmngr
#
# curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.2
#
sudo apt-get install mariadb-server

#
nano /etc/mysql/my.cnf
#
#
[mysqld]
character-set-server=utf8
bind-address = `db_server_ip`
# require_secure_transport = on
#
mysql_secure_installation
# 
# mysql_ssl_rsa_setup --uid=mysql

#
mysql -u root -P 33066 -p

SELECT user,host,password FROM mysql.user;
SHOW DATABASES;
CREATE DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER `user`@`remoteipaddress` IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON databasename.* TO `user`@`remoteipaddress`;

ufw allow in on $PUBLIC_INF from $PUBLIC_CLIENT_IP_ADDRESS to any port $POSTGRES_PORT
ufw allow in on 10.10.1. from $PUBLIC_CLIENT_IP_ADDRESS to any port $POSTGRES_PORT