Setting up for Kodi media imports from a NAS over NFS, how to set up Maria DB or MySQL DB for media library, setting up kodi to use mysql, importing video media sources, importing music media sources, changing skins & considerations on finding the "best" skin for you: lightweight skins for Raspberry Pi, and configurability. Kodi Compendium [Part 5]: Basic Configuration, Adding Media, Skins.

Subscribe and visit me here: http://grokshop.tv

Find it on Amazon:
https://www.amazon.com/shop/grokshop

**SQL COMMANDS**
Get the port which the DB is bound to:
SHOW GLOBAL VARIABLES LIKE 'PORT';

give perms to the kodi bot user (osmc in this case, YMMV)
GRANT ALL ON . TO 'osmc';

Notes:
One some linux platforms, you can also get the port-process binding from the command line with:
netstat -tlnp
(look at the last column for mysql)
However on Synology, the process fields come up empty for me.

Music:
Special THANK YOU to my friends at Epidemic Sound!
https://player.epidemicsound.com

* We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites