Enable Password Mysql

MySQL: Grant **all** privileges on database

grant all privileges on mydb.* to myuser@'%' identified by 'mypasswd';
grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd';

on MariaDB server, the file may live below

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

bind-address                               = 0.0.0.0

sudo systemctl restart mysql.service
sudo systemctl restart mariadb.service
sudo ufw allow from 192.168.1.5 to any port 3306

SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';