MariaDB

Install and Configure MariaDB

Install MariaDB on Ubuntu

curl -LsS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash

sudo apt-get install mariadb-server mariadb-client

MariaDB Secure Installation

sudo mysql_secure_installation

Create Database and Grant User Access

sudo mysql -u root

create database dbname;

CREATE USER 'username'@'localhost' IDENTIFIED BY 'p@ss';

GRANT ALL ON dbname.* TO 'username'@'localhost';

flush privileges;

Import Database

mysqldump -u root dbname | gzip > dbname.sql.gz

Export Database

gunzip dbname.sql.gz

mysql -u root dbname < database.sql

References

• Cara Install MariaDB

• Perintah Dasar MySQL