Kodi is an excellent media player to play your DVD backups and other multimedia stored on your WD NAS.
This guide explains how to setup a central Kodi database to keep your watched content in sync on all your Kodi devices.
In other words: a common library and watched status on your TV, laptop, tablet and phone… you can pause a movie on your TV and continue watching in another room.
Step 1: Install phpMyAdmin
It is an app in the official WD app store.
When you click configure, use admin - admin to login.
The top row has items such as “Databases”, “SQL”, “Status”, “Users”, …
Select Users.
Step 2: Add kodi user
Create a new user by clicking “Add user”
Fill in username = kodi
Leave host open
Fill in password = kodi (or use the generate button)
Don’t create a database.
Click check all in the privileges tab.
(fine tuning can be handled later)
Finish off by click “Add user” at the bottom.
Step 3: setup Kodi clients
Create a file “advancedsettings.xml” with the following contents
Replace the ***.***.***.***
with the IP address of your PR2100 / PR4100
If you used a random password, make the necessary changes.
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
Now copy this “advancedsettings.xml” file to the userdata directory of your Kodi client.
Android: /sdcard/Android/data/org.xbmc.kodi/files/.kodi/userdata/ (see note)
iOS /private/var/mobile/Library/Preferences/Kodi/userdata/
Linux ~/.kodi/userdata/
Mac /Users/<your_user_name>/Library/Application Support/Kodi/userdata/
LibreELEC/OpenELEC /storage/.kodi/userdata/
Windows Start - type %APPDATA%\kodi\userdata - press <Enter>
For more info: check this url
Start Kodi again. Your library will be empty, but when you scan your directories again, the mysql database will fill up.
For information about library backups, look here.
Now enjoy your synced Kodi clients!