The World According To Vissie

Create new user

mysql -uroot -p
CREATE USER 'user'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON \*.\* TO 'user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

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

[mysqld]
bind-address		= 0.0.0.0

sudo systemctl restart mariadb.service