MariaDB installieren

sudo apt update
sudo apt upgrade
sudo apt install mariadb-server

mysql

sudo mysql_secure_installation

neue Datenbank

sudo mysql -uroot -p
CREATE DATABASE CaravanPiValues;

neuer User

CREATE USER 'caravanpi'@'localhost' IDENTIFIED BY 'caravanpi';
GRANT ALL PRIVILEGES ON CaravanPiValues.* TO 'caravanpi'@'localhost';
FLUSH PRIVILEGES;

sudo mysql -ucaravanpi -p