Create mysql/mariadb DB and user

mysqladmin create somename_workdb

for user from any host:

CREATE USER 'somename_workdb'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON somename_workdb.* TO 'somename_workdb'@'%';
FLUSH PRIVILEGES;

for user from localhost only:

CREATE USER 'somename_workdb'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON somename_workdb. * TO 'somename_workdb'@'localhost';
FLUSH PRIVILEGES;

 

Add remote host to firewall in order to allow connection to mysql:

 

tcp|in|d=3306|s=host_ip