# Installation Mariadb

[![Capture d’écran 2022-06-13 à 14.27.42.png](https://wiki.fuseboat.co/uploads/images/gallery/2022-06/scaled-1680-/capture-decran-2022-06-13-a-14-27-42.png)](https://wiki.fuseboat.co/uploads/images/gallery/2022-06/capture-decran-2022-06-13-a-14-27-42.png)

> Ici on va sur le site de mariadb on selectionne la version à installer: 
[Mariadb repos](https://mariadb.org/download/?t=repo-config&d=Debian+11+%22Bullseye%22&v=10.8&r_m=mva)

## installation du dépot maraidb 10.8:
```sh
sudo timedatectl set-timezone Europe/Zurich \
&& sudo apt update \
&& sudo apt-get install apt-transport-https curl qemu-guest-agent \
&& sudo curl -o /etc/apt/trusted.gpg.d/mariadb_release_signing_key.asc 'https://mariadb.org/mariadb_release_signing_key.asc' \
&& sudo sh -c "echo 'deb https://mirror.mva-n.net/mariadb/repo/10.8/debian bullseye main' >>/etc/apt/sources.list" && sudo reset
```

## Install mariadb
```sh
sudo apt update \
&& sudo apt install -y mariadb-server mariadb-client \
&& sudo systemctl enable mariadb && sudo systemctl start mariadb
```

## On commence ca configuration:
```
sudo mysql_secure_installatio

Switch to unix_socket authentication [Y/n] Y
Change the root password? [Y/n] Y
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y
```

## connection distante:
```sh
sudo mysql -u root -p
```
```mysql
GRANT ALL PRIVILEGES ON *.* TO 'mon_user'@'%' IDENTIFIED BY 'mot_de_passe' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
```

## Activation de connection distante & augmentation des perfs:
```sh
sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
```
```conf
# Permet la connection distante
bind-address = 0.0.0.0
# Selon la ram disponible
innodb_buffer_pool_size = 4G
``