grant all privileges on *.* to 'root'@'192.168.1.%' identified by 'songbin' with grant option;

select user,host from mysql.user where host<>'localhost';

nano /etc/mysql/my.cnf

port=3306

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

bind-address=0.0.0.0