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
Avez-vous aimé cet article ?