[Milhouse]

I run texturecache from same Windows PC that hosts MySQL. Guess i need to dig a little deeper, also thanks for the advice about setting log on texturecache, for the Kodi log, would simply turning on debug be enough to capture what is needed?

The X and Xd commands require direct access to the filesystem of the device running Kodi, so if you're running the script on Windows for a remote Android client then it's likely your Windows PC simply can't access the Android filesystem, hence all the rows being listed (the textures database for the client can be accessed via JSON, but to test that the cached image files exist in the Thumbnails folder requires - unfortunately - direct filesystem access).

Presumably you've configured the userdata and/or thumbnails property in some way so that it references the Android filesystem from the Windows PC, so I would suggest checking this path and ensuring your Windows PC has read/write access. Run texturecache.py config to see the paths being used by userdata and thumbnails (they will be concatenated together userdata+thumbnails to generate the full path to the client Thumbnails image folder).