Installation Mariadb

Ici on va sur le site de mariadb on selectionne la version à installer: Mariadb repos

installation du dépot maraidb 10.8:

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

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:

sudo mysql -u root -p

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:

sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf

# Permet la connection distante
bind-address = 0.0.0.0
# Selon la ram disponible
innodb_buffer_pool_size = 4G
``