Installation de la database

Entrez ces commandes en SSH

Création de la Database

mysql -u root -p USE mysql; CREATE USER 'pterodactyluser'@'127.0.0.1' IDENTIFIED BY 'motdepasse'; GRANT ALL PRIVILEGES ON . TO 'pterodactyluser'@'127.0.0.1' WITH GRANT OPTION; FLUSH PRIVILEGES;

Création d'un compte USER :

mysql -u root -p USE mysql; CREATE USER 'pterodactyluser'@'%' IDENTIFIED BY 'motdepasse'; GRANT ALL PRIVILEGES ON . TO 'pterodactyluser'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES;

nano /etc/mysql/mariadb.conf.d/50-server.cnf

Puis remplacer :

127.0.0.1 -> 0.0.0.0

Aperçu :

bind-address = 0.0.0.0

Et ensuite restart MYSQL

systemctl restart mysql