=====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 
<sxh bash; gutter: false>
[mysqld]
bind-address		= 0.0.0.0
</sxh>
  sudo systemctl restart mariadb.service