Create new user

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

Connect from outside localhost

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

[mysqld]
bind-address		= 0.0.0.0


sudo systemctl restart mariadb.service