SYNCING via RPI2 and mysql

[keebler]

starting my next project of syncing all the rpi's.
i have a RPI2 running mysql
1 RPI3 running XBIAN
2 RPI2's running XBIAN
2 RPI's running XBIAN

so here is the problem
here is the important part of the advancedsettings.xml

<advancedsettings>
<!-- VERSION 20160330.A -->
<videodatabase>
<type>mysql</type>
<host>192.168.1.80</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>adminvideo</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.80</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>adminaudio</name>
</musicdatabase>

then i have various substitutions, etc. (the substitutions, all seem to work fine)

the IP address of the RPI running mysql IS 1.80

i guess my REAL question lies with MYSQL running on Rasbian on RPI2
the settings in MYSQL, etc
any suggestions would be greatly appreciated

thank you

[Nachteule]

So WHAT is your problem?

[Nachteule]

I have similar configuation (4 Pi's, one Hummingboard, 1 Linux Desktop, 1 Linux Notebook) and Database on Cubieboard2 server

I managed this some years ago, these sites helped me doing this job:

http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL
http://www.howtogeek.com/75535/how-to-sync-your-media-across-your-entire-house-with-xbmc/

[keebler]

(31st Mar, 2016 09:39 PM)Nachteule Wrote:  So WHAT is your problem?

sorry,

the RPI's (TV's) wont talk to the MYSQL RPI.

[Nachteule]

Does your mysql listen on all interfaces?

extract of /etc/mysql/my.cnf

Code:

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
bind-address            = ::