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