The World According To Vissie

This is an old revision of the document!

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