I’ve set up Kodi to use a mysql database on a Vero 4k+ and I’ve also set Kodi clients up on a Win10 and Pi4 so I know it works.
I’m trying to copy the MyMusic72.db file from the Vero 4k+ to Windows so I can run an experimental python script that basically imports my playcounts from Last.fm (Kodi.tv forum link). I know the script works more or less because I’ve used it before when I just had a single (non-mysql) Kodi on the Vero 4k+.
I can use Putty on Windows to get to /var/lib/mysql/MyMusic72 (folder) but it won’t let me go any further. I can also use VNC on the Pi4 to get to the same folder but again I can’t go any further. “Permission denied”
I’ve exhausted my very limited knowledge and unsure how to proceed, or even if I can. Is it a file permissions problem or maybe mysql (mariadb) is blocking me from getting into that folder?
I’m open to any advice/suggestions.