> For the complete documentation index, see [llms.txt](https://book.linuxsec.org/server/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://book.linuxsec.org/server/lemp/mariadb.md).

# 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](https://www.linuxsec.org/2018/07/cara-install-mariadb.html)
* [Perintah Dasar MySQL](https://www.linuxsec.org/2017/01/perintah-mysql.html)