1 - change bind-address to network address:
#nano /etc/mysql/my.cnf
and set:
bind-address = 10.1.0.10
2 - restart service:
#/etc/init.d/mysql restart
3 - create user and give permission:
mysql>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
mysql>GRANT ALL ON *.* TO 'xbmc'; FLUSH PRIVILEGES;
4 - more:
mysql>GRANT ALL ON movies.* TO root@'192.168.56.1' IDENTIFIED BY 'PASSWORD';
mysql>update db set Host='192.168.56.1' where Db='movies';
mysql>update user set Host='192.168.56.1' where user='root';
mysql>SET PASSWORD FOR 'root'@'192.168.56.1' = PASSWORD('*** password here ***');