my steps
1. sudo apt-get install mariadb-server
2. sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
3. The the bin-address
eg
bind-address = 192.168.1.10
4. sudo service mariadb restart
5. mariadb -u root -p
Enter the following commands:
Type in: CREATE USER 'kodi' IDENTIFIED BY 'kodi'; and press return
Type in: GRANT ALL ON *.* TO 'kodi'; and press return
Type in: flush privileges; and press return
Close out the command line tool with \q
I add the following advancedsetting file in both devices

my advancedsettings.xml

<advancedsettings version="1.0">
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.10</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.10</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
<video>
  <excludefromscan>
      <regexp>[-\._ ](extrafanart|sample|trailer|extrathumbs)[-\._ ]</regexp>
  </excludefromscan>
  <excludefromlisting>
      <regexp>[-._ \\/](extrafanart|sample|trailer|extrathumbs)[-._ \\/]</regexp>
  </excludefromlisting>
  <!-- Featurettes: Section Start -->
  <excludefromscan action="append">
      <regexp>/Featurettes/</regexp>
      <regexp>[\\/]Featurettes[\\/]</regexp>
  </excludefromscan>
  <excludetvshowsfromscan action="append">
      <regexp>/Featurettes/</regexp>
      <regexp>[\\/]Featurettes[\\/]</regexp>
  </excludetvshowsfromscan>
  <!-- Featurettes: Section End -->
</video>
</advancedsettings>

Nothing happens of second device