Article #14
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;
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
127.0.0.1 -> 0.0.0.0
bind-address = 0.0.0.0
Et ensuite restart MYSQL
systemctl restart mysql